Forum Discussion

ganchevd's avatar
ganchevd
Icon for Helper I rankHelper I
8 years ago
Solved

Difference between due date and selected calendar date

Hello,   I have an issue by making the calendar slicer affect the days overdue. From the table bellow:   Customer name Cust No. Document date Document No.: Due date Invoiced Ending balan...
Need Help
Tips and Tricks
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    You would need to create a measure, which should be something like:

     

    Measure = 
VAR MaxDate = MAX('Calendar'[Date]) // Or MAXX(ALLSELECTED('Calendar'),[Date])
VAR DueDate = MAX('Table'[Date])
RETURN DATEDIFF(MaxDate,DueDate,DAY)
ganchevd's avatar
ganchevd
Icon for Helper I rankHelper I
8 years ago

Thank you. It is working. It changes dates but when I try to add the column into the table above it breaks. Probably something with the link between calendar table and the data table. Is there any difference if the Calendar Table is prepared in Power Query Mode? Is there a way to do it as Calculated column. Since the data is huge and it is refreshing very slowly. I tried to put the same formula in Column, but it did not work properly. I received one and the same value for each of the rows.

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

ganchevd,

 

Values in a calculated column are fixed. They are an immutable result for each row in the table.