Forum Discussion

Mayank_Yavda's avatar
Mayank_Yavda
Resolver II
4 years ago
Solved

need help with calculated column

I have a table named A in which i have two column - date and sales - and i have another table B with three columns - start date , end date and category - where in table B I only have 4 rows for 4 cat...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Mayank_Yavda 

    Pls try to create a column

    Column = MAXX(FILTER(TableB,TableB[Startdate]<='TableA'[date]&&TableB[Enddate]>='TableA'[date]),TableB[Category])

    pls see the attachment below.

mh2587's avatar
mh2587
Super User
4 years ago

Would you provide data and expected output