topic calculate days between due date and today in DAX Commands and Tips

calculate days between due date and today

Anonymous — Wed, 19 Jul 2023 11:06:06 GMT

am having issues with a DAX measure, if i create it in PBI Desktop the measure works. If i create the DAX statement in Azure Analysis server and i refresh the data it is not giving issues so you might think it will work. FYI, the dataset i used in PBI desktop is the same as in AAS.

This is the DAX statement used:

DaysDifference =
VAR DueDateFromDimensionalTable =
CALCULATE(
MAX('[Dim_DueDate]'[DateValue])
)
RETURN
DATEDIFF(TODAY(), DueDateFromDimensionalTable, DAY)

Once uploaded to PBI service it is not working:

not sure what goes wrong and, even more important, how to solve this.

Hope someone can help....

thanks!!

Re: calculate days between due date and today

Mahesh0016 — Wed, 19 Jul 2023 13:14:03 GMT

Anonymous Please try this, I hope this helps you!
DaysDifference =
VAR DueDateFromDimensionalTable =
MAX('[Dim_DueDate]'[DateValue])
RETURN
DATEDIFF(DueDateFromDimensionalTable,TODAY(),DAY)

Re: calculate days between due date and today

Anonymous — Wed, 19 Jul 2023 13:56:07 GMT

Hi Mahesh,

have modified DAX, will have to wait till tomorrow.

Will let you know if it is okay or not.

In the meantime, thanks for your swift reponse, appreciate it!!!

Re: calculate days between due date and today

Anonymous — Thu, 20 Jul 2023 09:46:05 GMT

hi Mahesh,

as expected, the change did not work... sorry! This is the error message i receive when using the measure:

the weird thing is, in PBI Desktop (use exactly the same dataset) it is working properly (DAX Statement here was not changed to the specs from you)=

So, i added the DAX to the Azure Analytic Service cube and after Deployment to PBI service, it did not work anymore. Am confused.