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.
Hi
I have used a measure to calculate Aged Debt - please see the measure calculation below:
When i insert this measure into a Table Visual the result will not display - a wheel keeps spinning in the top left of the visual... what am i doing wrong?
I want to create a measure that subtracts sales invoice date from todays date.
Thanks in advance for your help
Solved! Go to Solution.
Hi @Sean-OReilly ,
See if this helps.
https://community.powerbi.com/t5/Desktop/Debt-Aging/m-p/1067551
https://community.powerbi.com/t5/Desktop/Dynamic-Accounts-Receivable-Aging/m-p/304192
Else try this as a measure
invoicedatedif =
IF (
MAX ( working[InvoiceDate] )
< TODAY (),
DATEDIFF (
TODAY (),
MAX ( working[InvoiceDate] ),
DAY
),
BLANK ()
)
Hi @Sean-OReilly ,
See if this helps.
https://community.powerbi.com/t5/Desktop/Debt-Aging/m-p/1067551
https://community.powerbi.com/t5/Desktop/Dynamic-Accounts-Receivable-Aging/m-p/304192
Else try this as a measure
invoicedatedif =
IF (
MAX ( working[InvoiceDate] )
< TODAY (),
DATEDIFF (
TODAY (),
MAX ( working[InvoiceDate] ),
DAY
),
BLANK ()
)
Thanks a million Harshnathani
Hi,
Please try the below function.
invoicedatedif = IF ( CALCULATE ( MAX ( working[InvoiceDate] ) ) < TODAY (), DATEDIFF ( TODAY (), CALCULATE ( MAX ( working[InvoiceDate] ) ), DAY ), BLANK () ) |
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
thanks for your response.
Unfortunately i am getting an error - see screenshot below... cant see where im going wrong?
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |