Shows Data Based on Date

[hilmandenis]

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 relationship between 2 tables, 'All Promo Details' and 'Date', based on [End Date] column.

Actually, there are several promos that are currently active right now. How can I show the promos that currently active based on start date and end date in date slicer? Its something like this, [Start Date] =< [start date slicer] and [end date slicer] >= [End Date]. Please help me.

[v-xicai]

Hi   @hilmandenis ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

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.

[amitchandak]

I have blog active employees. Seems similar problem. Refer

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[hilmandenis]

Wow, it sure like a high-level report. I need and will learn about it first. Thanks @amitchandak 

[Tahreem24]

@hilmandenis ,

Change Cross filter direction of Relationship  to "Both" as per your screen shot.

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

[hilmandenis]

It still shows the same result. I edited my question so maybe it will give you a better understanding about my problem.