Forum Discussion

hilmandenis's avatar
hilmandenis
Frequent Visitor
6 years ago

Shows Data Based on Date

Hey everyone, I want to create a report that shows all active promo based on date slicer.     Right now it shows only promo that has [End Date] before 10 January 2020, because I create the ...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi hilmandenis ,

 

You may create measure Filter1 like DAX below, , then put the Filter1 in the Visual Level Filter of table visual which displays [Promo Name] and other fields, setting Filter1 as "is not blank".

 

Filter1=
Var FromDate = CALCULATE(MIN(Date[Date]),ALLSELECTED(Date[Date]))
Var ToDate = CALCULATE(MAX(Date[Date]),ALLSELECTED(Date[Date]))
Return
IF(MAX('ALL Promo Details'[Start Date])>=FromDate &&MAX('ALL Promo Details'[End Date])<=ToDate, 1, BLANK())

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.