Forum Discussion

Frequent Visitor

2 years ago

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

Need Help

Ashish_Mathur

Super User

2 years ago

Hi,

It will be nice if you can share some data to work, explain the simple logic of what you want done. Show also the expected result. With this much information, I am sure i can simplify your measures.

NasiraliKarwar

Frequent Visitor

2 years ago

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.