Forum Discussion

Rajeeb701's avatar
Rajeeb701
New Member
2 years ago
Solved

Matrix table in Power BI

Hi ,   I have attached 02 screenshots .. one is rawdata, second one is output view. In output page need to add two slicer (Report date 01 and report date 02) user can select those data according t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Rajeeb701 

     

    You can try the following methods.

    The first step is also, to select the first four columns-Unpivot Other Columns.

    Dates can be made into slicers.

    Measure = 
    Var _mindate=CALCULATE(MIN('Table'[Report date]),ALLEXCEPT('Table','Table'[Report date])) 
    Var _maxdate=CALCULATE(MAX('Table'[Report date]),ALLEXCEPT('Table','Table'[Report date]))    
    Var _min=CALCULATE(MAX('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Head Property],'Table'[Property],'Table'[Demise Reference],'Table'[Attribute]),[Report date]=_mindate))
    Var _max=CALCULATE(MAX('Table'[Value]),FILTER(ALLEXCEPT('Table','Table'[Head Property],'Table'[Property],'Table'[Demise Reference],'Table'[Attribute]),[Report date]=_maxdate))
    Return
    IF(_min=_max,TRUE(),FALSE())
    Result = IF(HASONEVALUE('Table'[Report date]),SELECTEDVALUE('Table'[Value]),[Measure])

    Result:

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.