Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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.