Forum Discussion
LAndris
Helper I
Helper ISlow changing Dimension with Date Range Filter
Hello, I am attempting to create a report in Power Bi that will use a date range slicer to filter the following two tables Table 1: Slow changing Claim Dimension with StartDate EndDate and o...
Hi LAndris ,
I try to reproduce your scenario, please check if this is what you want:
Measure = VAR MaxDate_ = MAX ( Dates[Date] ) RETURN IF ( MAX ( 'Table 1'[StartDate] ) <= MaxDate_ && MAX ( 'Table 1'[EndDate] ) >= MaxDate_, 1 )BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Icey
Community Support
Community SupportHi LAndris ,
I try to reproduce your scenario, please check if this is what you want:
Measure =
VAR MaxDate_ =
MAX ( Dates[Date] )
RETURN
IF (
MAX ( 'Table 1'[StartDate] ) <= MaxDate_
&& MAX ( 'Table 1'[EndDate] ) >= MaxDate_,
1
)
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.