Forum Discussion
FIlter Data Based On Slicer Selection
Continued ContributorDo you have a limited number of values in the "Date Period" column?
If so then you can create a new column on your [tblSales] table for each value.
E.g. This Week = if(lookupvalue(tblDateSelections[Start Date],tblDateSelections[Date Period],"This Week") <= [InvoiceDate] && lookupvalue(tblDateSelections[End Date],tblDateSelections[Date Period],"This Week") >= [InvoiceDate],1,0)
Assuming you had a date range called "This Week".
This solution would only give me a 1 or 0 for that date period. I have columns within the tblSales that flag each date range already eg WTD-Flag, MTD-Flag etc. In an ideal world what I want to do is;
- select a date range period from a slicer which is populated from a table with all the date range selections
- this selection to then change a value in a column called MasterDate-Flag within tblSales which would update all relevant records within this column to a 1 or 0 dependant on the date period selected
- this column would then be used as filter criteria for the report, page or visualisation
Hope this makes sense and thanks for the proposed answer.
Cheers
- dramus
Let me see if I can restate the problem, to see if I understand.
You want a column on the Sales data that shows whether this record has been selected based on the filtered values in the Dates table?
alsmHelper III
SmithyBowMassiv I know many years have passed, were u able to solve this problem? any idea how?