cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SweetLana
New Member

undefined

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!

1 REPLY 1
BA_Pete
Super User
Super User

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors