Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help creating Column by Phase and scan date

Hello everyone,    Im needing help creating a formula that will look at a certain uploaded phase date by department #. Basically what i have is certain phases that were changed on a upload date. I ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You can create column Phase_matched to meet your demand.

     

    Phase_matched =
MAXX (
    TOPN (
        1,
        FILTER (
            Table1,
            Table1[Department] = Table2[Department]
            && Table1[Upload on] <= Table2[Scan Date]
        ),
        Table1[Upload on], DESC
    ),
    Table1[Phase]
)

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes the top one would give me Phase 3 and the bottom Phase 2

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So anything scanned from upload date on Phase 1 until Upload date on Phase 2 would be a Phase 1 product and so on