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

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

Power BI Monthly Update - April 2024

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