Forum Discussion
Helper VTwo different measure in one chart/table summarized by the same date
Hello,
I have been having difficulty trying to get the same correct number for the closed lost and closed won at the same time in one chart due to the fact that they have different date to be referenced.
right now im only getting correct numbers for closed lost since the link for closed won is inactive.
This is what my model looks like at the moment with struggling to have both relationship:
My goal is to have the sum of closed won and closed lost can be combined in one chart/one table summarized by month-year (MMM-YY) format as seen below
any tips to fix the issue?
Hi cruzp
You can achieve the desired results with userelationship function , please refer to my answer by the link:
https://community.fabric.microsoft.com/t5/Desktop/Count-and-graph-multiple-dates-in-the-same-table/m-p/4062736/highlight/true#M1288760
It includes pbix with example.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
2 Replies
- Ritaf1983
Super User
Hi cruzp
You can achieve the desired results with userelationship function , please refer to my answer by the link:
https://community.fabric.microsoft.com/t5/Desktop/Count-and-graph-multiple-dates-in-the-same-table/m-p/4062736/highlight/true#M1288760
It includes pbix with example.If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
