Forum Discussion

s4spencer's avatar
s4spencer
Regular Visitor
5 years ago
Solved

Table visualization - "hide" columns when summarizing

Hi,   I'm trying to "summarize - last" based on a specific column, for example:   Index | Letter | Date 0 | A | 22/12 1 | B | 22/12 2 | A | 23/12 3 | B | 23/12   I want to "summarize - last...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi s4spencer ,

     

    First create a dimensional date table as below:

    Date table = VALUES('Table'[ Date])

    Then create a measure as below:

    _Index = 
var _table=CALCULATETABLE(VALUES('Table'[Index ]),FILTER(ALL('Table'),'Table'[ Date] in FILTERS('Table'[ Date])))
Return
IF(NOT(ISFILTERED('Date table'[ Date])),MAX('Table'[Index ]),
IF(MAX('Table'[Index ]) in _table,MAX('Table'[Index ]),BLANK()))

    Remember to create a relationship between fact table and date table:

    Finally you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi s4spencer ,

 

First create a dimensional date table as below:

Date table = VALUES('Table'[ Date])

Then create a measure as below:

_Index = 
var _table=CALCULATETABLE(VALUES('Table'[Index ]),FILTER(ALL('Table'),'Table'[ Date] in FILTERS('Table'[ Date])))
Return
IF(NOT(ISFILTERED('Date table'[ Date])),MAX('Table'[Index ]),
IF(MAX('Table'[Index ]) in _table,MAX('Table'[Index ]),BLANK()))

Remember to create a relationship between fact table and date table:

Finally you will see:

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!