Forum Discussion

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago
Solved

Previous quarter report level filter for 3 different data sources

I have three data sources and linked all three using date (year, quarter, month).   I'm curious how do I go about using previous quarter in my page filter that would apply to all 3 data sources. Th...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi diskovered

    One workaround is to create measure to show values of previous quarter.

    for example, create measures

    current_quarter = COUNT(Table1[Date])

previous_quarter = CALCULATE(COUNT('Table1'[Date]),PREVIOUSQUARTER('date table'[Date]))

     

    Best Regards

    Maggie

diskovered's avatar
diskovered
Icon for Helper III rankHelper III
7 years ago

Thanks for your help. Relative filter doesn't have previous quarter. Can this be done using a measure? Something like this? 

 

PREVIOUSQUARTER = PREVIOUSQUARTER(dim_Date[calendar_date])

 

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi diskovered

One workaround is to create measure to show values of previous quarter.

for example, create measures

current_quarter = COUNT(Table1[Date])

previous_quarter = CALCULATE(COUNT('Table1'[Date]),PREVIOUSQUARTER('date table'[Date]))

 

Best Regards

Maggie

  • diskovered's avatar
    diskovered
    Icon for Helper III rankHelper III
    7 years ago

    Perfect, I think I'll settle with this workaround. Thank you