Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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".
Solved! Go to 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/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
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
User | Count |
---|---|
121 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |