Forum Discussion
aaashton
Jun 10, 2022Copper Contributor
Help with a pivot
Hello, I have a spreadsheet that has columns Deal Name, Owner, Phase 1, Phase 2, and Phase 3. The Phase columns will have the date the deal has completed that phase; so it can be blank if not compl...
SergeiBaklan
Jun 11, 2022Diamond Contributor
In addition to mathetes and assuming you are not on Mac, to calculate all phases completed you may add data to data model creating PivotTable and use such measure
Completed :=
CALCULATE (
COUNTROWS ( Table1 ),
Table1[Phase1] > 1,
Table1[Phase2] > 1,
Table1[Phase3] > 1
)