Forum Discussion
Creating slicer for date using a column from one table to select a value from another table
Hi all,
I need your help with the following issue:
I have 2 tables for eg : A & B . Table B has multiple columns out of which one of them is 'Date' .Table A & B has one column in common with many to many relationship. The main goal is to create a slicer using Date column from table B to make selection for 'KPI Value' column in table A . Table A & B are not connected.
So, if anyone please help me with the issue.
2 Replies
- amitchandak
Super User
Anonymous , if A and B are not joined
//Filter Date in A
new measure =
var _max = maxx(allselected(B),B[Date])
var _min= minx(allselected(B),B[Date])
return
calculate(Sum(A[Value]), filter(A, A[date] >= _min && A[Date]<= _max)) Hi Anonymous ,
With the information you have provided so far, I'm afraid we can't offer you the right solution. Maybe you can provide some sample data, backend logic and your expected result, etc., and we will provide you with a suitable solution based on your information later. Thank you.
how to retrieve selected values from another table (with no relationship)
IF Clause, get value from another table
Best Regards
