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.
Hi team,
I need to show only previous month and next five months data in power query. i have tried with DAX its working but its not working in slicer.
suppose my data is like below, i need to show only previous and next 4 months data as highigheted in screenshot.
Regards,
Kusa
pls try this
= Table.SelectRows(#"Changed Type",
each [Date] >=Date.StartOfMonth( Date.AddMonths( Date.From( DateTime.LocalNow()),-1))
and [Date]<= Date.EndOfMonth( Date.AddMonths( Date.From( DateTime.LocalNow()),3)))
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |