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 ChampionForces 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
maraclesResolver II
Resolver IIVery useful. Thanks.