Forum Discussion
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...
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.
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.
Thanks ryan_mayu, with some changes according to my requirement your solution is working fine for me.
you are welcome
