Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a report showing table data based on a date selecting from a calender date value.
The issue am facing is while selecting a calender date column from slicer based on that table data need to apply one criteria which is
if user is selecting date 09-08-2023,
report will show based on below condition
created_date >=01-08-2023 and Created_date<31-08-202 and Expiry date <=09-08-2024
Solved! Go to Solution.
Hi @NISHA_S ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a measure as below
Flag =
VAR _seldate =
SELECTEDVALUE ( 'Calendar'[Date] )
VAR _selcdate =
SELECTEDVALUE ( 'Table'[Created date] )
VAR _seledate =
SELECTEDVALUE ( 'Table'[Expiry date] )
RETURN
IF (
_selcdate >= DATE ( YEAR ( _seldate ), MONTH ( _seldate ), 1 )
&& _selcdate < EOMONTH ( _seldate, 0 )
&& _seledate <= _seldate,
1,
0
)
2. Create a table visual and apply the filter with the condition (Flag is 1)
Best Regards
Hi @NISHA_S ,
I created a sample pbix file(see the attachment), please check if that is what you want.
1. Create a measure as below
Flag =
VAR _seldate =
SELECTEDVALUE ( 'Calendar'[Date] )
VAR _selcdate =
SELECTEDVALUE ( 'Table'[Created date] )
VAR _seledate =
SELECTEDVALUE ( 'Table'[Expiry date] )
RETURN
IF (
_selcdate >= DATE ( YEAR ( _seldate ), MONTH ( _seldate ), 1 )
&& _selcdate < EOMONTH ( _seldate, 0 )
&& _seledate <= _seldate,
1,
0
)
2. Create a table visual and apply the filter with the condition (Flag is 1)
Best Regards