How to recode payment from 1 = 30 day 2= 60 day ?

[Paulyeo11]

[v-yiruan-msft · Accepted solution]

Hi @Paulyeo11 ,

You can create a calculated column just as show in below screenshot:

_TERM = SWITCH('AR'[TERM],BLANK(),"No term",1,"30 day",2,"60 day","Other")

Best Regards

[Paulyeo11]

Hi Ying

Thank you so much , it work fine now. 

Now i notice that for the raw data payment term , the field value is text or whole number make a lot of diff. 

Paul

[Paulyeo11]

https://www.dropbox.com/s/d1j4vk2s5xc1utj/PBT_V2021_93%201%20ROW%20JAN13%20AR%20ADL%20ONLY%2030%20ro...

My PBI file

[amitchandak]

@Paulyeo11 , You can create a new column like

Switch( True(),
1, "30 Days",
2, "60 Days"
)

[Paulyeo11]

Hi Amit

Thank you , where to insert the field name TERM in your propose expression ?

[amitchandak]

@Paulyeo11 , In the table you have column term , you need to create this new column