Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Use datetable with multiple dates in one table

I am quite new to Power Bi, and I'm just getting started to understand the basics of it. Now, I came across a problem. I have got a data set with a table with customer support tickets containing mul...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , find the use of use relation here

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

 

Try like

Ticket Created = CALCULATE(COUNT(Ticket[Ticket Id ]),USERELATIONSHIP(Ticket[CreatedDate ],'Date'[Date]) )

Ticket Closed = CALCULATE(COUNT(Ticket[Ticket Id ]),USERELATIONSHIP(Ticket[ClosedDate],'Date'[Date]))

 

Join both dates with the date calendar. Use relation is optional with active join.

 

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

Anonymous's avatar
Anonymous
Not applicable
6 years ago

That's it!

 

The problem I was facing actually had nothing to do with the relationships.

My dataset uses datetime (dd/mm/yyyy hh:mm:ss) and the calendar I made obviously uses date (dd/mm/yyyy). I thought I formatted the dataset correctly in Power BI, but apparently BI is still unable to handle these (sort of) 'different' datatypes, although they look exactly the same. Had to change the dates in PowerQuery itself to make it work.

Anyways, Thanks a lot!