Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I need to compute the due date base on Credit term given from invoice date.
For example row 1
Total number of due date = 16 + 3 = 19 day
Can some one share with me how to compute above ?
My PBI file :-
https://www.dropbox.com/s/hazvc34zcvuydui/AR%20ADL%20V006.pbix?dl=0
Paul
Solved! Go to Solution.
Hi,
This calculated column formula works
Column = today()-(AR_S[AR Invoice Date]+AR_S[TERM])+1
Hope this helps.
Thank you for the expression , can you pls help me create the expression for those over due company. So that when I tick 1 , it is filter all over due client
Hi,
This calculated column formula works
Column = today()-(AR_S[AR Invoice Date]+AR_S[TERM])+1
Hope this helps.
Thank you for the expression , can you pls help me create the expression for those over due company. So that when I tick 1 , it is filter all over due client
@admin11 , Due days as a new column
Datediff([AR Invoice Date]+ [Term], Today(), day)
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |