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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.