Forum Discussion

AlmantasPBIguy's avatar
AlmantasPBIguy
Frequent Visitor
4 years ago
Solved

Filtering Current + last quarter

Hey guys, I am trying to display brand awareness, of various brands current quarter TD vs last quarter in a clustered column chart. I can't finda way, how to filter out current and previous q...
Need Help
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, AlmantasPBIguy ;

    You could create a flag column in table.

    flag = 
var _to=TODAY()
return IF(YEAR([Date])=YEAR(_to)&&QUARTER([Date])=QUARTER(_to),1, 
          IF(QUARTER(_to)=1,IF(YEAR([Date])= YEAR(_to)-1&&QUARTER([Date])=4,1),IF(QUARTER([Date])=QUARTER(_to)-1,1)))

    Then apply it in all page filter.

    The final output is shown below:

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, AlmantasPBIguy ;

You could create a flag column in table.

flag = 
var _to=TODAY()
return IF(YEAR([Date])=YEAR(_to)&&QUARTER([Date])=QUARTER(_to),1, 
          IF(QUARTER(_to)=1,IF(YEAR([Date])= YEAR(_to)-1&&QUARTER([Date])=4,1),IF(QUARTER([Date])=QUARTER(_to)-1,1)))

Then apply it in all page filter.

The final output is shown below:

 


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlmantasPBIguy's avatar
AlmantasPBIguy
Frequent Visitor
4 years ago

Thanks, this helped me out!