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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Enter this calculated column formula in TableA

Category = calculate(max(TableB[category]),filter(TableB,TableB[Start Date]<=earlier(TableA[Date])&&TableB[End Date]>=earlier(TableA[Date])))

Hope this helps.