Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have searched for a solution for this issue, but so far none of them have worked for me. Here's the scenario:
I have a report that calculates the Sales YTD-1 using this measure:
@PowerBI_RD , You should try meausres like
YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))
Make sure the date table fields are used in measure, visual and slicer
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Unfortunately that makes no difference for the total, that's still calculating the entire month.
My question basically is why is there a differerence between the way YTD-1 behaves with regards to the total, with one report showing the total up until today, and the other one showing the total till the end of the current month. With these reports having the same formulas and basically the same setup.
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |