Forum Discussion
maracles
Resolver II
Resolver IIColumn data type locked to Date
I have three tables. 1. Order Facts with a date column called First Published. This stores a date and Power BI, as expected, allows me to change the format on the modelling tab to whatever I want ...
Try adding a "*1" to your formula for the final measure and see if that helps:
Time to Delegation = ([First Published Date Max] - [First Assigned Date Max]) * 1
Or use DATEDIFF with an interval of DAYS:
https://msdn.microsoft.com/en-us/library/dn802538.aspx
Greg_Deckler
Community Champion
Community ChampionTry adding a "*1" to your formula for the final measure and see if that helps:
Time to Delegation = ([First Published Date Max] - [First Assigned Date Max]) * 1
Or use DATEDIFF with an interval of DAYS:
https://msdn.microsoft.com/en-us/library/dn802538.aspx
maraclesResolver II
Resolver IIGreg_Deckler the "*1" worked great. If you dn't mind, why does that work?
Thank you.
- Greg_Deckler
Forces it to be returned as a number instead of a date type, basically in DAX data type logic, Date - Date = Date whereas Date * Number = Number
- Greg_Deckler
Forces it to be returned as a number instead of a date type, basically in DAX data type logic:
Date - Date = Date whereas Date * Number = Number
- maracles
Very useful. Thanks.