Forum Discussion
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...
HI sroy
Try adding this calculated column
New Column = CALCULATE ( FIRSTNONBLANK ( Table1[Flag], 1 ), FILTER ( ALLEXCEPT ( Table1, Table1[Group] ), Table1[Status] = "Complete" ) )
Zubair_Muhammad
Community Champion
Community ChampionHI sroy
Try adding this calculated column
New Column =
CALCULATE (
FIRSTNONBLANK ( Table1[Flag], 1 ),
FILTER ( ALLEXCEPT ( Table1, Table1[Group] ), Table1[Status] = "Complete" )
)
Hi Zubair_Muhammad This works! What if the label wasnt always in the complete row?
- Zubair_Muhammad
In that case, simply :smileytongue:
New Column = CALCULATE ( FIRSTNONBLANK ( Table1[Flag], 1 ), ALLEXCEPT ( Table1, Table1[Group] ) )Thank you!!