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 have two measures;
Is there another way to calculate YTD or is there anything else to consider when using YTD?
Many Thanks
Andy
@Anonymous , YTD should be like
Att YTD2 = CALCULATE([Overall Att rate],DATESYTD('dimDates'[Date]))
and dimDates should be marked as a date table
Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw
it still calculates the same value without the filter, i added the filter in the hope that was the issue as we only work on acedemic years and dont want to count non school days.
DimDates is marked as a date table
We
Hi @Anonymous ,
According to your description, you want dates not including weekends, here’s my solution.
1.Create a new date table.
2.Use the date table to calculate.
Or you are still confused about it, please provide me with a sample and the output you expect.
About DATESYTD function, you can refer to the following blog:
https://docs.microsoft.com/en-us/dax/datesytd-function-dax
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The question is more around what is YTD doing to my measure?
my assumption was that YTD was including non school days, weekends holidays etc and rounding the numbers over the extra days.
I have selected last year
When I put the overall measure in a line chart by month it reports the same calculation as the YTD measure.
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 |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |