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.
I want to compute a ytd that can be seen with the total increasing after each date where a new DLY occurs.
Any direction or advice would be greatly appreciated since the YTD function cannot be run with identical dates. ! I've tried many things so far with creating a new date table but it is causing me issues, maybe on how I connected the two queries.
I suppose the end result would look something like this. Anything I would be able to select a date and see the YTD.
Thanks,
Lucas
Solved! Go to Solution.
Based on your sample data (there is no DLY value to total on?), you can add a column stripping off the time, then do TOTALYTD off of that column
Column
Dt = DATEVALUE(DurTab[DLY_ST])
Measure
YTD = TOTALYTD(SUM(DurTab[DLY_DUR]), DurTab[Dt])
Hope this helps
David
Hi @test_123_e213,
One sample for your reference. If it doesn't meet your requirement, kindly share your excepted result to me.
Regards,
Frank
Thanks for your help too!
Both answers were the same but it was still nice to see.
Lucas
Based on your sample data (there is no DLY value to total on?), you can add a column stripping off the time, then do TOTALYTD off of that column
Column
Dt = DATEVALUE(DurTab[DLY_ST])
Measure
YTD = TOTALYTD(SUM(DurTab[DLY_DUR]), DurTab[Dt])
Hope this helps
David
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |