Pull Data from table1 if date is = today or more and from table2 if the date < today

[Anonymous]

Hello, I want to use the Data from one table (Table1) if the Date is equal to Today or in the future and use Data from another table (Table2) if the Date is less than Today date.

Please help - Thanks

[v-jiascu-msft · Accepted solution]

Hi @Anonymous ,

If the data is from a SQL database, you can send a SQL query. The general solution could be filtering them in the Query Editor. 

Please refer to the snapshot below.

= Table.SelectRows(#"Changed Type", each [Column1] >= Date.From(DateTime.LocalNow()))

Best Regards,

[Anonymous]

Hi,

In fact my data are coming from 2 differents .csv files one for Table1 and the 2nd for Table2

Should I use the same filtering principle.

Please, I would need a little more detail as I am quite new in Power BI world

Thanks !!

[v-jiascu-msft]

Hi @Anonymous ,

Yes, you only need to apply these steps once. You will always get the desired data when you refresh the report.

Can you see the image in my last post, which contains details?

Best Regards,

[Anonymous]

Yes - I can see the image

Many Thanks  you for your help!