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.
Image attached of dummy data - hope this helps
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.
Proud to be a Super User!
You're right, as I've no idea where to start - will review the article
Thanks
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.
User | Count |
---|---|
342 | |
99 | |
63 | |
51 | |
49 |
User | Count |
---|---|
327 | |
120 | |
84 | |
68 | |
63 |