Forum Discussion
User selected multiple date filters SOS
Hello, I am trying to create a report which will have two different sets of tables that are filtered by two different dates. The user must be able to select the two dates they want compared, and th...
Hi,
you are providing very little information, which makes it difficult to give precise answers. It would also be helpfull to know which ideas you have already tested. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Based on the information you have given, I would suggest having 2 date tables, and create 2 measures for the same variable:
sales1=calculate(sum(sales);all(datetable2))
sales2=calculate(sum(sales);all(datetable1))
and add two slicers to the report, one from each date table.
regards,
Sturla