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.
Hi all,
In a scenario, the monthly cycle runs between the 7th working day to next month's 7th working day.
Example: November 2023 month starts from 7th working (09-Nov) and ends on 7th working day of Dec (11-Dec).
How can I achieve this to show all the months in RESULTING MONTH calculated column correctly like below
Thanks for you help in advance.
Solved! Go to Solution.
I have the first and last day of my cycle like this
not like yours
check, are you correct?
You are right. I have updated my image in original post to show correct dates for Dec.
Could you please share your pbix/dax? Thanks
Worked! thank you so much
Add that identifier to your existing Calendar table.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |