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)))