Forum Discussion
datediff dax -formula
this is sovled-rather than using a new measure in the report view- i used dax datediff in the data(table view) and datediff works just fine to get sla from one date compared to another (calendar days for this purpose) and can be set for hours or weeks or days-i chose days and sla achieved via dax date diff after all--closing this one as solved- thanks all
the issue is in the table the date is listed as long form month day and hour and minute but when i move to the report it gives me in the date table only month and day and year and quarter so i guess since the report is not showing the hour and minute as in the table then it wont activate the normal datediff identifier
That's not the reason. Look at the DAX code before that spot.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
