Forum Discussion

Mayank_Yavda's avatar
Mayank_Yavda
Icon for Resolver II rankResolver 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.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
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.

Mayank_Yavda's avatar
Mayank_Yavda
Icon for Resolver II rankResolver II
4 years ago

Thanks ryan_mayu, with some changes according to my requirement your solution is working fine for me.

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    4 years ago

    you are welcome