cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mrooney
Frequent Visitor

HelpDesk data - how to show all data for a month in the year

Hi, real beginner to this.

I've got all of my data loaded and it includes columns such as date opened, date resolved etc. What I'm having a challenge with is displaying all of the data from a specific week/month/year. If I choose to filter or use a splitter to show all calls opened in Jan, the calls resolved figure will not be correct as the data will only show that which is on the same line as a call opened in Jan. Same if I choose to split by calls resolved dates.

What I'm trying to get is a flat date splitter/filter where it will simply say all data from January 2016 for example. Then I could accurately see that this many lines have a Jan open date and this many a Jan resolved, giving accurate figures for the month.

Hope that makes sense to someone - seems really complicated to explain but I guess to summarise I'm looking for a calendar splitter at a high level, for the data to then be pulled onto.

Thanks everyone
5 REPLIES 5
tringuyenminh92
Memorable Member
Memorable Member

Hi @Mrooney,

 

As my understand, you want to show calculation of value for same period of Open date and Resolve date. I think you should refer topic side by side role-playing in power bi 

The idea is having same date table for display but calculation will be computed by specific relationship of kind of date (open/resolve)

If it's not what you are expecting, please share me sample data and your expectation as picture. So I could quickly figure out solution.

Untitled.png

 

 

 

 

 

 

 

Image attached of dummy data - hope this helps

Mrooney
Frequent Visitor

The bottom line on the image above is a perfect example of a call which was opened in one month and closed in another

i would consult the article posted by tringuyenminh92 - what you want is to do calculations on your dates to provide the side by side analysis of the dates.  This will probably mean you need to acquire a slighly more complex understanding of how dax works.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




You're right, as I've no idea where to start - will review the article

 

Thanks

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!