"PREVIOUSQUARTER"

[JDMakita]

Hello,

I am building a custom slicer in which I want to be able to slice to previous year, quarter, and month. I cant figure out what needs to be entered here after the "PREVIOUSQUARTER".

[v-luwang-msft · Accepted solution]

HI @JDMakita ,

You could test to make a previous Qtr flag on the query editor:

=Table.AddColumn(#"Changed Type1", "Previous Qtr Flag", each if [Date] <= Date.AddMonths(Date.From(DateTime.LocalNow()),-3) then 1 else 0)

Refer:

https://community.powerbi.com/t5/Desktop/Previous-Quarter-to-Date-with-Quarter-Slicer/m-p/524375/hig... 

https://community.powerbi.com/t5/Desktop/Current-Quarter-and-last-quarter-calculation/m-p/703345

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Lucien