Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to raise a number to the power of the difference between two dates. All of my value columns are formatted as decimal number, and the difference between the dates is around 4, but I am getting this error when I try to make a Calculated column
"An argument of function 'POWER' has the wrong data type or the result is too large or too small."
Hi @heardm,
Based on my test in desktop version 2.47.4766.801 64-bit (June 2017), we can create a calculated column like below:
Column = POWER(DATEDIFF('Table2'[StartDate],'Table2'[EndDate],DAY),2)
Both [StartDate] and [EndDate] columns are date type.
In your scenario, please run the same desktop version and create the same calculated column like us.
Besides, please go through the DATEDIFF() and POWER() functions carefully.
Best Regards,
Qiuyun Yu
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
79 | |
64 | |
62 | |
56 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |