Forum Discussion
Anonymous
5 years agoNot applicable
How to recode payment term ?
Hi All
My PBI file :-
https://www.dropbox.com/s/fyu4bl1t0jlzs8d/PB_TDS_V065%20ASK%20RECODE%20PAYMENT%20TERM.pbix?dl=0
Anonymous , Please find the file. New column created
3 Replies
- amitchandak
Super User
- AnonymousNot applicable
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
- AnonymousNot applicable
Hi Remyo
when i try i am not able to click okay