Forum Discussion

NimaiAhluwalia's avatar
NimaiAhluwalia
Continued Contributor
11 months ago

Hello 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.

  • leodec11's avatar
    leodec11
    Frequent Visitor
    11 months ago

    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