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,
In Power Query, I have a Start Date Query, which is being calculated dynamically in the text format. Example: 01/06/2020
and I have this code:
Source = {Number.From(#date(Number.FromText(Text.End(#"Start Date",4)),1,1))..Number.From(#date(Number.FromText(Text.End(#"End Date",4)),12,31))}
I want to use Start Date Query as an input in the code above (replacing 'Start Date' and 'End Date').
Is it possible to do it in the Power Query code above please?
Thank you.
Solved! Go to Solution.
Managed to find a solution:
Source = {Number.From(Date.FromText(#"Start Date"))..Number.From(Date.FromText(#"End Date"))}
Managed to find a solution:
Source = {Number.From(Date.FromText(#"Start Date"))..Number.From(Date.FromText(#"End Date"))}
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.