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 All,
I need help in calculating the dates difference for one of my scenario as below
i want to calculate current date minus invoice date >7 or invoice date is null as single calculation.could some body please help me on this .
Regards
Neetha
Solved! Go to Solution.
Hi, @Anonymous
You can try the following methods.
Sample data:
Column:
Difference = DATEDIFF([Invoice date],TODAY(),DAY)
Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Difference]>7))
+CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Invoice date]=BLANK()))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Fantastic! You've supplied a sample output, do you mind supplying some sample input as well? How did you get those 1s and 4s when the current date is December 8, 2022?
HI hnguy,
its the invoice count i placed for test data.
Hi @Anonymous ,
It's always nice if you can supply a sample data and expected output. The more detailed the information the better. With what you've given, the best anyone can do is nudge you in the right direction.
Your expression would be:
CALCULATE([YOUR_MEASURE], YOUR_DATE_FIELD > TODAY() - 7 || YOUR_INVOICE_FIELD = BLANK() )
Hi hnguy,
below is the screen shot of data.i want to calculate the current date - invoice date >7 or invoice date is null so that i know how many invoices are delayed
Hi, @Anonymous
You can try the following methods.
Sample data:
Column:
Difference = DATEDIFF([Invoice date],TODAY(),DAY)
Measure = CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Difference]>7))
+CALCULATE(SUM('Table'[Count]),FILTER(ALL('Table'),[Invoice date]=BLANK()))
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Hnguy,
Thanks for quick reply.
i want to calculation as if current date - invoice date >7days or invoice date is null.
i dont have any measures.
Hi @Anonymous ,
If you don't currently have a base measure, then it would be the aggregate value of whatever field you're attempting to calculate.
Replace [YOUR_MEASURE] with whatever you're attempting to do... perhaps a SUM, AVERAGE, MAX, etc.
Am I understanding your request?
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 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |