Forum Discussion

paulfink's avatar
paulfink
Icon for Post Patron rankPost Patron
4 years ago
Solved

Custom Quarter - Quarter Button Slicer

Hi guys,   Need a hand in making a formula for a Column that returns either Current Quarter or Previous Quarter so i can use those to put into a slicer to filter my pages.   This is what i have s...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi paulfink ,

     

    Create a calculated column.

    FYQ = 
var FYM = EDATE('Table'[date],-6)
return
FORMAT(FYM,"yyyyq")

    Then create two measures.

    current = CALCULATE(MAX('Table'[FYQ]),FILTER('Table',FORMAT('Table'[date],"yyyymm")=FORMAT(TODAY(),"yyyymm")))

previous = CALCULATE(MAX('Table'[FYQ]),FILTER('Table',FORMAT('Table'[date],"yyyymm")=FORMAT(EDATE(TODAY(),-3),"yyyymm")))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi paulfink ,

 

Create a calculated column.

FYQ = 
var FYM = EDATE('Table'[date],-6)
return
FORMAT(FYM,"yyyyq")

Then create two measures.

current = CALCULATE(MAX('Table'[FYQ]),FILTER('Table',FORMAT('Table'[date],"yyyymm")=FORMAT(TODAY(),"yyyymm")))

previous = CALCULATE(MAX('Table'[FYQ]),FILTER('Table',FORMAT('Table'[date],"yyyymm")=FORMAT(EDATE(TODAY(),-3),"yyyymm")))

 

Best Regards,

Jay