Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |