cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User

Hi @Ronzey ,

``````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!

Super User

Hi @Ronzey ,

``````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!

Announcements

#### New forum boards available in Real-Time Intelligence.

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

#### Power BI Monthly Update - May 2024

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

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors