Measure for Created vs Closed vs Approved vs remaining open per month - just need the remaining

[GreggT]

Hi, i'm new to powerbi and trying to work out how to add a measure to calculate items that have been approved but not implemented by month 

in my data table I have the columns 

Created Date - always has date

Closed Date - has date if closed or null if not closed

Date Approved - has date if approved of null

I have a seperate date table linked to Created date,

Created = COUNTROWS(fcr)

with a userelationship for closed

Closed Date = CALCULATE(COUNTROWS(table), USERELATIONSHIP(Dates[FullDateKey], table[Closed Date]),NOT(ISBLANK(table[Closed Date])))

userelationshup for date approved

Date Approved = CALCULATE(COUNTROWS(table), USERELATIONSHIP(Dates[FullDateKey], table[Date Approved]),NOT(ISBLANK(table[Date Approved])))

the last piece of the puzzle is I want to see the total number of items awaiting implementing per given month

which would be  if a record has an approved date in the selected time period, but no closed date in that period

e.g.

month 1 30 approved 15 implemented (15 remain open)

month 2 10 approved 8 implemented (17 remain open)

 c

[v-chuncz-msft]

@GreggT,

You may apply virtual relationship in DAX to add an appropriate measure.

https://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[GreggT · Accepted solution]

sorry didn’t find this particularly helpful, and somewhat confusing

I’m just after a cumulative date of ‘items approved but not closed in a given month/week/year whatever the user selected as date axis’. 

Thanks anyway