CSV folder load , How to filter Imvoice_Date > 1 April 2022 ?

[admin11]

Hi All

i am loading 5 raw data CSV file by folder from SharePoint folder. 
Below are the 5 file :- 

GL_A

GL_B

GL_C

GL_D

GL_E

File extendsion CSV

After loading to PBI , I have create a field SOURCE to differentiate the file by below label :- 

A

B

C

D

E

For SOURCE=E , I need to filter Filed=Invoice_Date > 1 April 2022

can some one advise me how to do it ?

Paul

[amitchandak · Accepted solution]

@admin11 , when you add them as folder and then expand using binary then you will get file name in each row in a new column. 

Create a new column in power query

= if [source name] <> "E.csv" then 1 

else if [Date] > #date(2022,4,1) then 1 else 0

and then filter for 1

[admin11]

@amitchandak 

May I know how to do at Power Quary ? So that I don't need to modify my existing expression. As only one raw data file need to be filter invoice date. 

Paul

[admin11]

@amitchandak very good point. thank you for give me the idea. i need to implement it .