Forum Discussion
Convert 2 Measures to Calculated Columns (Sample PBIX File attached)
I have, in the example, 2 tables joined together by "Absence ID" and then have 2 working measures that 1) count the number of days during a period that are backfilled by someone and 2) count the numb...
You could create a DAX table using the SUMMARIZE function:
My Table = SUMMARIZE('Absence Master', 'Absence Master'[Absence ID], "Min Date", MIN(Date0, "Max Date", MAX(Date)...
This creates a table with the aggregations as columns.