I need to add a third column to matrix visual showing the difference between the filtered period columns. The value for each row in the period column is calcuated from the same field.
1 ACCEPTED SOLUTION
hi, @magutierrez1
try this one
Period Difference =
VAR CurrentPeriod = MAX('YourTableName'[PeriodField])
VAR PreviousPeriod = CALCULATE(MAX('YourTableName'[PeriodField]), FILTER(ALL('YourTableName'), 'YourTableName'[DateField] < MAX('YourTableName'[DateField])))
RETURN CurrentPeriod - PreviousPeriod
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
hi, @magutierrez1
try this one
Period Difference =
VAR CurrentPeriod = MAX('YourTableName'[PeriodField])
VAR PreviousPeriod = CALCULATE(MAX('YourTableName'[PeriodField]), FILTER(ALL('YourTableName'), 'YourTableName'[DateField] < MAX('YourTableName'[DateField])))
RETURN CurrentPeriod - PreviousPeriod
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
