Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
So I have landed up in a unique problem here :-
I have a date table and my dataset. My dataset is directly connected to the date table. My dataset is something similar to this: -
TaskID | Open Date | Closed Date |
1 | 1/1/2014 | 2/3/2016 |
2 | 3/4/2016 | 6/7/2017 |
3 | 9/1/2016 | 5/12/2017 |
4 | 7/31/2015 | 1/5/2018 |
Now I want to plot a visual with number of tasks open and closed in the past 3 years (one visual with 2 lines). However, my date table is connected to either closed or open date. How do I fix this? I do not want to connect my date table. Just want to use that as a reference.
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi,
Try this
Cases opened = COUNT(Data[TaskID])
Cases closed = CALCULATE(COUNT(Data[TaskID]),USERELATIONSHIP(Data[Closed Date],Calednar[Date]))
Hope this helps.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português