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.
Hello Team,
Can someone help me understanding how the above command will work and if in Duration (1,0,0,0) if I replace 1 by 2 or 3 what will happen ?
My understanding - above will create a column with date starting from May 31, 2020 and will last till 1 year and will have date as May 31, 2020 , June 1, 2020, June 2, 2020 etc.. as the duration has 1 day if I change it to 2 it would be May 31, 2020, June 2, 2020, June 4, 2020
Is the understanding correct ?
Solved! Go to Solution.
Hi @koolsid786
For the most part your assumptions are right. It will create a list with dates starting May 31, 2020
The second argument is a count and the third step as duration. When you incease the step from 1 to 2 days a list will be generated with 365 list items, making the end date or last list item May 5, 2022
Please mark this answer as solution when it helped you to resolve your question, thanks!
Your explanation is correct. The first value in #duration is days. Also, FYI that people typically use this approach to dynamically get the right count to make sure they get 1 year (leap year, etc.).
= List.Dates(#date(2020,05,31), Duration.TotalDays(#date(2021,6,1)-#date(2020,5,31)), #duration(1,0,0,0))
Pat
Hi @koolsid786
For the most part your assumptions are right. It will create a list with dates starting May 31, 2020
The second argument is a count and the third step as duration. When you incease the step from 1 to 2 days a list will be generated with 365 list items, making the end date or last list item May 5, 2022
Please mark this answer as solution when it helped you to resolve your question, thanks!
See here
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.