Forum Discussion
New in Power BI - Using two date filters
- Anonymous4 years ago
Hi nachoroncero ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure = VAR _start = DATE ( 2017, 1, 1 ) VAR _value = CALCULATE ( SUM ( 'Table'[value] ), FILTER ( ALL ( 'Table' ), 'Table'[date] >= _start && 'Table'[date] <= SELECTEDVALUE ( 'Table 2'[Date] ) ) ) RETURN _valueCancel the work of the slicer on the guage, select Format>>Edit interaction.
Then choose none.
Then filter the data on this visual.
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nachoroncero ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
VAR _start =
DATE ( 2017, 1, 1 )
VAR _value =
CALCULATE (
SUM ( 'Table'[value] ),
FILTER (
ALL ( 'Table' ),
'Table'[date] >= _start
&& 'Table'[date] <= SELECTEDVALUE ( 'Table 2'[Date] )
)
)
RETURN
_value
Cancel the work of the slicer on the guage, select Format>>Edit interaction.
Then choose none.
Then filter the data on this visual.
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.