Forum Discussion
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 categories.
So i want to add a column in table A such that if date in table A lies between Start date and end date of Table B then it returns category based on date range it lies in.
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.
5 Replies
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
Would you provide data and expected output
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.
