Forum Discussion

Snap's avatar
Snap
Frequent Visitor
4 years ago
Solved

Fill down based on rank

Hi, I have the below table. I am trying to fill down the empty categories. The current dax formula I am trying get working is:   Category fill down = if('Table'[Category]=blank(),CALCULATE(lastNON...
Need Help
  • Snap's avatar
    Snap
    4 years ago

    Managed to solve with the below:

     

    VAR LastNonBlankDate =
    CALCULATE (
    LASTNONBLANK ( 'Table'[Rank], 1 ),
    FILTER (
    ALL ( 'Table' ),
    'Table'[Rank] <= EARLIER ( 'Table'[Rank] )
    && NOT ( ISBLANK ( 'Table'[Category]) )
    )
    )
    RETURN
    CALCULATE (
    FIRSTNONBLANK('Table'[Category],'Table'[Category]) ,
    FILTER ( ALL ( 'Table' ), 'Table'[Rank] = LastNonBlankDate )
    )
Snap's avatar
Snap
Frequent Visitor
4 years ago

Managed to solve with the below:

 

VAR LastNonBlankDate =
CALCULATE (
LASTNONBLANK ( 'Table'[Rank], 1 ),
FILTER (
ALL ( 'Table' ),
'Table'[Rank] <= EARLIER ( 'Table'[Rank] )
&& NOT ( ISBLANK ( 'Table'[Category]) )
)
)
RETURN
CALCULATE (
FIRSTNONBLANK('Table'[Category],'Table'[Category]) ,
FILTER ( ALL ( 'Table' ), 'Table'[Rank] = LastNonBlankDate )
)