Forum Discussion

slc7456's avatar
slc7456
Advocate III
8 years ago
Solved

Rolling Month and Quarter Calculation

Purpose: Calculate Rolling 12 months and Rolling Quarter based off todays date    Background: I would like to display data only from the last 12 calendar months. Power BI offers this as a relative ...
Need Help
  • slc7456's avatar
    slc7456
    8 years ago

    I created  Current Quarter Flag which allows me to filter my page on the current quarter. My rolling quarters issue is solved. Breakdown below

     

    Curent Year = YEAR(TODAY())

    Quarter = ROUNDUP([MonthNumber]/3, 0)

    Current Quarter = ROUNDUP(MONTH([Current Date])/3, 0) 

    Current Quarter Flag = if([Current Quarter] = [Quarter] && 'Date Dimension'[Year] = [Curent Year],"Y","N")

     

     

     

     

slc7456's avatar
slc7456
Advocate III
8 years ago

I created  Current Quarter Flag which allows me to filter my page on the current quarter. My rolling quarters issue is solved. Breakdown below

 

Curent Year = YEAR(TODAY())

Quarter = ROUNDUP([MonthNumber]/3, 0)

Current Quarter = ROUNDUP(MONTH([Current Date])/3, 0) 

Current Quarter Flag = if([Current Quarter] = [Quarter] && 'Date Dimension'[Year] = [Curent Year],"Y","N")