Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |