Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate a new column using data from the same row

I have a table in Power BI with the following 3 columns:   Incident Number, Date Opened, Date Closed It has about 1,000 rows, covering 3 years.   I want to create a graph showing how many incide...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Nearly there.

 

[Open Count] = CALCULATE(COUNTROWS('Incidents'),'Incidents'[Date Opened] < [Date]),COALESCE('Incidents[Date Closed],[Date]) > [Date])