Forum Discussion

itsyash007's avatar
itsyash007
New Member
8 years ago
Solved

Get trends with 2 different dates in a single chart

I have data for multiple tickets in an excel tracker. I want to represent two trends on a chart in PowerBI.   First one is 'Received Volume' depending on the 'Received Date' Second one is 'Complet...
davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
8 years ago
Hi, Do you have an anonymised sample of your data that you could upload?
itsyash007's avatar
itsyash007
New Member
8 years ago

Hi, Below is my existing table and the output that I am expecting. I am able to get the unique dates in the new table but not able to get the tickets received and completed. Note: For tickets completed, I need to consider 'Date completed' with status as 'Completed.

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi itsyash007,

     

    You may download my solution from here.

     

    Hope this helps.