Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I have a query which has a date column, which has date from 2000.01.01 to 2099.12.31. I want to filter the date from 2016.01.01 till now.
I therefore write in the M code as
= Table.SelectRows(#"Renamed Columns", each[Date] < Date.From(DateTime.LocalNow()) )
= Table.SelectRows(#"Filtered Rows", each [Date] >= #date(2016, 1, 1))
Then due to analysis requirement, I need the date list to be from 2016.01.01 till 21 days into the future. How should I modified the first M code so that it is possible?
I tried with Date.From(DateTime.LocalNow()+21), but it was obviously not working....
Thanks in advance.
Solved! Go to Solution.
Hi @Qianru221,
It seems that you are looking for this function Date.AddDays.
You could try to this formula below.
Date.AddDays (Date.From (DateTime.LocalNow ()) , 21)
For reference, you could have a good look at this similar thread.
Best Regards,
Dale
Hi @Qianru221,
It seems that you are looking for this function Date.AddDays.
You could try to this formula below.
Date.AddDays (Date.From (DateTime.LocalNow ()) , 21)
For reference, you could have a good look at this similar thread.
Best Regards,
Dale