How to recode payment term ?

[Paulyeo11]

Hi All

My PBI file :-

https://www.dropbox.com/s/fyu4bl1t0jlzs8d/PB_TDS_V065%20ASK%20RECODE%20PAYMENT%20TERM.pbix?dl=0

[amitchandak · Accepted solution]

@Paulyeo11 , Please find the file. New column created

[Anonymous]

You could make a table which you link to this table

You table would translate

key                          new value

1 to 030 days         1 to 030 days

1                            1 to 030 days

2 to 060 days        2 to 060 days

2                           2 to 060 days

Display new value in your report

You could also transform values in PowerQuery

[Paulyeo11]

Hi Remyo

when i try i am not able to click okay