Forum Discussion

Ronzey's avatar
Ronzey
New Member
3 years ago
Solved

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...
Need Help
Show and Tell
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
3 years ago

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