Forum Discussion

rashamohsen's avatar
rashamohsen
Frequent Visitor
6 years ago

Date filters

Hallow everyone   I have a problem with my date table, I created two Start date and End date, and they have four fields: Date, Day, Month and Year. I need to use two filter dates like Start date a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

rashamohsen 

Can you explain it with a sample pbix if possible, which helps us to understand your requirements. 

Based on the current information, can't you just create a slicer use the date column.

 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

rashamohsen's avatar
rashamohsen
Frequent Visitor
6 years ago

Hallo

Thanks for your reply, but I have a slicer (from my Date tables) like you mentioned, but my problem is that I do not know how to connect or to bind my Date tables with my Customer Table.

The report is about customer satisfaction.

I need tow Dates Start and edn date where the user can choose randolmy any date.

For my estimation I created a column incident, in this column I have to compare if the incident-Createddate  greater or less than the choosed Start date and the same for closed date and End date, to give incident a value from (-1,0 or 1).

But I can not use the Start and End date from my date tables, the DAX can't see them, it assumes that Start date has multiple values where it expects one value. I defined four variables like this:

 

 

Incident = Var EskBeginn = ('Incident'[System_CreatedDate])                                                                                        Var EskEnde = ('Incident'[Microsoft_VSTS_Common_ClosedDate])                                                                                        Var StartDtum = SELECTEDVALUE('StartDate'[Date])
Var EndDatum = SELECTEDVALUE('EndDate'[Date])
return IF(EskBeginn < StartDtum && EskEnde > StartDtum && EskEnde < EndDatum, 1, IF(EskBeginn > StartDtum && EskBeginn < EndDatum  && EskEnde > EndDatum, -1, 0))

 

 

selectedvalue did not help, and I can not make a relationship between the three tables.