I need help in developing a measure with DAX in Power BI

Budget 39$ per month

Posted: 5 years ago

Opened

Description: Hi everyone,

I've been trying to write a measure for cumulative pending cases where it should interact with date filter accordingly as the point in time.

I have data where I have a start date, enddate for each status of case and case submitted date.

The case submitted date is active relationship with a date column in the calendar table and an inactive relation between status start date and date.

In my scenario, there are a few different case statuses (P, V, F) which all together known as Pending.

I am using the following DAX, but it's not generating the required results.

Cumulative Measure = CALCULATE ( DISTINCTCOUNT( Data[GUID] ), FILTER('Data', AND('Data'[ENDDATE]= MIN('Date'[Date])) ))

The expected result is as follows where there are total 4 pending cases as of today on October, 7 pending cases at the end of Sep, 3 pending cases at the end of Aug and so on.
If we selected the date filter from 04/01/2018 to 07/10/2018. On 7th month (July) it should show the number of applications that are pending on 07/10/2018.
Skills:
development,power business intellegence (power BI)

Source: peopleperhour.com