Forum Discussion
Rajeeb701
2 years agoNew Member
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...
- Anonymous2 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.
BernatAgulloMVP
2 years agoMost Valuable Professional
What is the question?
- Rajeeb7012 years agoNew Member
Hi,
I need a view as similar as output screenshot which I attached .