Forum Discussion

mfarsln's avatar
mfarsln
Regular Visitor
6 years ago
Solved

Show or Hide Pivot Table Column Conditionally

Hello,   I have a pivot table with one row dimension, one column dimension (date) and two measures. What i want to do is that showing two measures if only its last date in the context.   For the ...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi mfarsln 

     

    You may download my PBIX file from here.
    Hope this helps.

     

    If I answered your question, please mark my post as solution, this will also help others.

    Please give Kudos for support.

parry2k's avatar
parry2k
Super User
6 years ago

mfarsln I looked at mwegener  solution and it is very clever, you need to change this to get the lastdate based on selection, change ALL to ALLSELECTED

 

var MaxDate = CALCULATE(MAX('Table'[date]),ALLSELECTED('Table'))

 

 

mfarsln's avatar
mfarsln
Regular Visitor
6 years ago

Thank you so much for your time. It works like magic when i change it to ALLSELECTED.