Forum Discussion
Fetching previous month value in calculation.
Hello, I am trying to fetch a value from a previous month in my further month's calculations: First logic: test overall due = CALCULATE(COUNT('Power BI'[Due Cases]), ALL('Power BI')) Sec...
Hello Ashish, What I am trying to achieve is this:
Calculation 1 - Overall Due Cases: If the due date is less than today's date, distinct count the Items. Dislay total due cases in January. For Rest months, previous value of Calculation 1 - Calculation 2
Calculation 2 - Overall Renewed Cases: If the Renew date is NOT BLANK, distinct count the Items. Dislay blank in January and values in rest months.
The dashboard has two tables: One coming from excel and another is a date table.
Outcome I am seeing:
Expected outcome:
Sorry I am not clear. Someone else may help you.