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.

v-xicai's avatar
v-xicai
Community Support
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.