Forum Discussion
Solved
2 individual matrix side by side
Hi I built the 2 matrix visual, first matric showing previous year calculation, 2nd matrix showing current last 3 months calculation where it has dynamic column headers in format mmm-yy. When I...
Answered this question here - Solved: Re: How to align multiple tables and create dynami... - Microsoft Fabric Community
NimaiAhluwalia
Continued Contributor
Continued ContributorHello leodec11
To better understand the request, can you please provide some visual images?
As per my understanding, you can put all the measures in a single matrix visual, you don't need 2 matrix to show, unless it is a business requirement.
Hi
thanks for replying.
table structure is
Specialty | PrevRatio | Jun-25 | Jul-25 | Aug-25 | CurrentRatio |,
the major problem is last 3 months dynamic headers, DAX measure built to show last 3 months ratio like this
DynamicRatio =
VAR OffsetMonths = SELECTEDVALUE(Last3Months[Offset])
VAR StartDate = EOMONTH(EOMONTH(TODAY(), -1), OffsetMonths) - DAY(EOMONTH(EOMONTH(TODAY(), -1), OffsetMonths)) + 1
VAR EndDate = EOMONTH(EOMONTH(TODAY(), -1), OffsetMonths)
VAR Num = CALCULATE(SUM('Query1'[RESULTVALNUMERATOR]), 'Query1'[Report Date] >= StartDate, 'Query1'[Report Date] <= EndDate)
VAR Den = CALCULATE(SUM('Query1'[RESULTVALDENOMINATOR]), 'Query1'[Report Date] >= StartDate, 'Query1'[Report Date] <= EndDate)
RETURN IF(Den <> 0, ROUND(DIVIDE(Num, Den), 3))
Last3Months is disconnected table to show column header dynamically in MMM-YY format
Hope it helps
Regards