Forum Discussion
AMBP1973
Helper III
Helper IIICalculate Date Status
Hi, I was wondering if someone could please assist with the following. I currently have the following DAX to calculate no. of documents overdue : Document Total Overdue = COUNTROWS(FILTER...
AMBP1973Helper III
Helper IIIHello bhanu_gautam ,
Thankyou for the measures you have provided, much appreciated. I created a Date Table = CALENDARAUTO() to include in these, however I am not getting any results in any visuals or a table?
However, I am not
AMBP1973Helper III
Helper IIIApologies, seems as though the message didn't come through properly.
Further to the above, I am not getting any results in any visuals or a table? Here is the measures I have created with the above date table:
Documents Overdue Current Month =
CALCULATE(
[Documents Overdue],
DATESINPERIOD('Date Table'[Date].[Date], MAX('Date Table'[Date]), -1, MONTH)
)
Documents Overdue Previous Month =
CALCULATE(
[Documents Overdue],
DATESINPERIOD('Date Table'[Date], MAX('Date Table'[Date]) - 1, -1, YEAR)
)
Variance =
[Documents Overdue Current Month] - [Documents Overdue Previous Month]
Could you please assist further? Many thanks.