Forum Discussion
Filter Slicer from Measure values
Hello eveyone,
I have 3 tables. Calendar, Sale and Parameter.
Parameter has values ranging from 1-24, which are the number on months I want to go back.
I am trying to filter a slicer which has ...
As you can see the start and end dates are not blank as shown in the card visual below.
try creating a temporary table like
tmp table =
ADDCOLUMNS ( VALUES ( 'Date'[date] ), "@step 1", [1 Step], "@step 2", [2 Step] )
and you can then use the data view to look for dates where either step 1 or step 2, or both, are blank.
Hi johnt75,
The new table did not work as start date is 31-12-1899 and the end date is blank.
I think is cause of the parameters used in the measures, when using them in a table, there is no context.
I tried modifying your code to use DATESBETWEEN() instead of CALENDAR(), it is not giving an error, but its not working either.
Anything else that you can think of?
You're right about the table lacking context. Try creating a table visual instead, use 'Date'[Date] and the two measures.