Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |