Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Fill blank values with previous value

Hi ,   I m new to power bi ,I have below dataset. In Target 2 column , blank values filled with previous value.Please help me to write dax  for same.   Year-Week       TARGET         TARGET2...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    6 years ago

    Anonymous 

     

    You can use the below Measure, I only changed the EARLIER function to MAX.

    Measure_Filldown  =
VAR LNBT = 
    CALCULATE(MAX('Table'[YEAR-WEEK]),
    FILTER(
        ALL('Table'),
        'Table'[YEAR-WEEK]<=MAX('Table'[YEAR-WEEK]) && 'Table'[TARGET]<>BLANK()
    )
    )
RETURN
CALCULATE(
    MAX([TARGET]),
    'Table'[YEAR-WEEK] = LNBT ,ALL('Table')
)


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

     

     

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Evaluation context in Column (Table) and Measure are different in this case.

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

Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

 

You can use the below Measure, I only changed the EARLIER function to MAX.

Measure_Filldown  =
VAR LNBT = 
    CALCULATE(MAX('Table'[YEAR-WEEK]),
    FILTER(
        ALL('Table'),
        'Table'[YEAR-WEEK]<=MAX('Table'[YEAR-WEEK]) && 'Table'[TARGET]<>BLANK()
    )
    )
RETURN
CALCULATE(
    MAX([TARGET]),
    'Table'[YEAR-WEEK] = LNBT ,ALL('Table')
)


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

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi ,

    I m getting one strange issue. I have connected DATA table with Date dimension and pulling Year-Week from date table. Its showing incorrect result when i sort measure2 based year-week order,otherwise its showing correct result.

    Using below formula

     

     

    Measure2 = VAR LNBT =
    CALCULATE(MAX('Date'[YEAR-WEEK]),
    FILTER(
    ALL('Date'),
    'Date'[YEAR-WEEK]<=MAX('Date'[YEAR-WEEK]) && RELATED(Data[TARGET])<>BLANK()
    )
    )
    RETURN
    CALCULATE(
    MAX([TARGET]),
    'DATA'[YEAR-WEEK] = LNBT ,ALL('DATE')
    )