Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
mb0307
Responsive Resident
Responsive Resident

Monthly Cylce from 7th Working Day

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

 

2023-11-05_16-33-11.jpg

 

Thanks for you help in advance.

1 ACCEPTED SOLUTION

5 REPLIES 5
Ahmedx
Super User
Super User

I have the first and last day of my cycle like this
not like yours
check, are you correct?

Screenshot_1.png

mb0307
Responsive Resident
Responsive Resident

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

pls try

Screenshot_2.pngScreenshot_3.png

mb0307
Responsive Resident
Responsive Resident

Worked! thank you so much

lbendlin
Super User
Super User

Add that identifier to your existing Calendar table.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.