Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Is there a simple way to convert durations computed from the difference of 2 dates into years, months and days
Solved! Go to Solution.
Hi @gancw1 ,
Please check the soultion in this post.
Solved: DAX to Convert days to Years,months & days - Microsoft Power BI Community
Best Regards,
Jay
Hi @gancw1 ,
Please check the soultion in this post.
Solved: DAX to Convert days to Years,months & days - Microsoft Power BI Community
Best Regards,
Jay
@gancw1 , You have convery
In power Query a new column diff
= [Duration1] - [Duraion 2]
Year=
Duaration.Days([Diff])/365.25
In this manner you have to calculate
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.