cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ronzey
New Member

How to get Relative Period?

I need help figuring out how to make a relative period. In a way were each quarter and month compares with Respective month in a quarter.

 

Example. Q1-MONTH 1 is relative to Q2-Month 1; Q3-Month 1 and Q4-Month 1

Q1-Month2 is relative to Q2-Month2; Q3-Month 2; Q4-Month 2

Q1-Month3 is relative to Q2-Month3; Q3-Month3; Q4-Month3. 

 

January Should compare to April; July, October

Febuary should compare to May, August, November

March Should compare to June, September, and December

 

This way it will know if its off month or a relative month.

 

Thank you

1 ACCEPTED SOLUTION
BA_Pete
Super User
Super User

Hi @Ronzey ,

 

In your calendar table, add a custom column something like this:

if List.Contains({1,4,7,10}, Date.Month([date])) then "QMonth1"
else if List.Contains({2,5,8,11}, Date.Month([date])) then "QMonth2"
else if List.Contains({3,6,9,12}, Date.Month([date])) then "QMonth3"
else null

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

1 REPLY 1
BA_Pete
Super User
Super User

Hi @Ronzey ,

 

In your calendar table, add a custom column something like this:

if List.Contains({1,4,7,10}, Date.Month([date])) then "QMonth1"
else if List.Contains({2,5,8,11}, Date.Month([date])) then "QMonth2"
else if List.Contains({3,6,9,12}, Date.Month([date])) then "QMonth3"
else null

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors