Forum Discussion

afbraga66's avatar
afbraga66
Helper III
5 years ago

Sort Matrix by dynamic column value based on filters

Hi,   I have a requirement to sort a matrix by the last possible month value, 7 in the example below. The issue is that Power BI only sorts by the total and that is not what I want.     I ...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

afbraga66 What about this version?

Today Month = 
    VAR __Date = MAX('DOWNTIME'[DIA_FABRIL])
    VAR __mDuration = CALCULATE([mDuration(min)],KEEPFILTERS(DOWNTIME[MES_FABRIL]=MONTH(__Date)))
RETURN
    IF(ISBLANK(__mDuration),
      BLANK(),
      __mDuration
    )
afbraga66's avatar
afbraga66
Helper III
5 years ago

Hey Greg_Deckler ,

Sorry to bother but any news on this topic?