Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi all, I am quite new to PBI and all what I have learnt was from online sources.
I need help with filtering data ( I belive in power query) so in my PBI I will have results only for 2023.
The data source contains queries raised by customers in the last 2022 and not yet being closed/ processed, so I need to apply filter only on solved queries.
Applying this on Filters, it doesn't show me data for opened ones.
Thanks in advance!
Hi @SweetLana ,
This should indeed be done in Power Query. Your filter code should look something like this:
Table.SelectRows(
previousStepName,
each Date.Year([completedDate]) = 2023 or [completedDate] = null
)
Pete
Proud to be a Datanaut!