calculate days between due date and today

[Anonymous]

hi

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!!

[Mahesh0016]

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

[Anonymous]

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!!!

[Anonymous]

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.