Forum Discussion
"PREVIOUSQUARTER"
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".
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/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
1 Reply
- v-luwang-msft
Community Support
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/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