Forum Discussion

mbarros's avatar
mbarros
Icon for Helper I rankHelper I
7 years ago
Solved

How to flag first entry only when second entry occurs?

Hello community! I'm struggling for days to figure this out, so your help will be greatly appreciated. I'm not able to write code myself from scratch, but I'm relatively good at googling, grabing co...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Got it! Even in Power BI it is the same logic, just need to use DAX.

    Create ID column by concatenating Company and Type of Sale (add date etc if you want)

    Create Status column using this-

    Status = IF(Table1[Type of Sale]="half", IF(IFERROR(LOOKUPVALUE(Table1[ID],Table1[ID],CONCATENATE(Table1[Company],"2nd half")),0)>0,"",Table1[Type of Sale]),Table1[Type of Sale])
     
    -Lakshmi
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is the Status column in Excel a formula? Or manually input?

  • mbarros's avatar
    mbarros
    Icon for Helper I rankHelper I
    7 years ago

    Hi Nick,
    I manually entered the STATUS column.