Forum Discussion

sroy's avatar
sroy
New Member
8 years ago
Solved

backfill data by group - dax question

In powerpivot, I have a table have a flag by group only when the status is complete. There is only one flag per group currently. I want to back fill the flag for the whole group for each status. Belo...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI sroy

     

    Try adding this calculated column

     

    New Column =
CALCULATE (
    FIRSTNONBLANK ( Table1[Flag], 1 ),
    FILTER ( ALLEXCEPT ( Table1, Table1[Group] ), Table1[Status] = "Complete" )
)
sroy's avatar
sroy
New Member
8 years ago

Hi Zubair_Muhammad This works! What if the label wasnt always in the complete row?

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

sroy

 

In that case, simply :smileytongue:

 

New Column =
CALCULATE (
    FIRSTNONBLANK ( Table1[Flag], 1 ),
    ALLEXCEPT ( Table1, Table1[Group] )
)

 

 

 

  • sroy's avatar
    sroy
    New Member
    8 years ago

    Thank you!!