How to add condition for SOURCE_AR for Recode Payment Term =1 to 30Days ?

[Paulyeo11]

[speedramps]

Please consider these solutions and click ‘accept solution’ and click the thumbs up to leave kudos, thank you.

Option1

In the query editor create a new conditional column

New payment terms =
If AR(SOURCE_AR) = “TS” then 1 – 30
else Payment Terms

Option2

Add a new table called Sources with

Source_AR          Terms

TS                           1 to 30
WK                         1 to 7
2WK                       1 to 14

Then create a relationship

[Paulyeo11]

Hi Speed

Thank you for your sharing.

My PBI file as per enclosed :-

https://www.dropbox.com/s/q33j2cnep5qkwpo/PB_TDS_V055%20ASK.pbix?dl=0

I have 2 fields , SOURCE and Payment term code:-

Paul Yeo