How to recode 1 to 30 Days 2 to 60 Days from Payment term field ?

[Paulyeo11]

Hi All

I am doing append , so i cannot use PQ to recode , as DAX i can just paste the code.

[Fowmy · Accepted solution]

@Paulyeo11

When you make a transformation in PQ, the steps will be applied whenever you load or refresh data. You do not need to repeat this process. However, if you need to do it in DAX, then, you shoudl create a an additional conditional column as follows:

New Column = 
SWITCH(
    [Column with number],
    1 , "30 Days",
    2, "60 days"
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube Linkedin

[Paulyeo11]

Hi Sir

In that case i need to do at PQ. thank you for sharing.

Does it mean that if i add new column in PQ , and when i append 2 table , the column will stay ? As when i as column in DAX , after i append the column missing

[Fowmy]

@Paulyeo11 

Didn't get the question right but if you want to replace those numbers with your own text, you can do it in power query using Replace Value. Right-Click on the column, select Replace Value and enter "30 Days" for example for number 1. Repeat for the numbers as well.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn


 

[Paulyeo11]

Hi Fowmy

I already know how to recode using PQ.

I need to learn how to recode using DAX.

Because now i try to learn append , and if i do in PQ , every time i need to manually do again and again, if i have DAX script , i can just copy and paste

Paul