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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.