Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
The answer to this problem was solved once before but the result isn't available anymore.
Here is the problem:
I need to calculate the Half year YTD of the previous period.
I've added a half year column to "DimDate" that computes the first half as 1 and second as 2.
My formula for the current half year goes like this:
Solved! Go to Solution.
@Anonymous , if you can have half-year start date, then you have a day of half-year, From that, you can now build it. Refer how to build it WTD. The same way you can build Half-year YTD
Similar logic I tested on custom Qtrs
@Anonymous , if you can have half-year start date, then you have a day of half-year, From that, you can now build it. Refer how to build it WTD. The same way you can build Half-year YTD
Similar logic I tested on custom Qtrs
The answer was in front of me and it was ridicolusly simple.
In case anyone is wondering. I've modifed the formula to this:
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |