Forum Discussion

DrEvil's avatar
DrEvil
Frequent Visitor
8 years ago
Solved

Diferent times in same row. Issue creeating graphs

  Hi, i have an Excel Sheet with a list of 'Issue Id' with the 'created' date and the 'resolved' date. I need to create a graph in Power Bi that shows how many Issues are CREATED each time period an...
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    DrEvil,

    For getting no of Issue Created, you will have the following

     

    Category - Month

    Value - Issue ID

     (The Above thing is already in place with you)

     

    For Getting count of no of Issues Resolved, you the below calculated column

     

    Count of Resolved IssueID = CALCULATE(COUNT(Table2[issue ID]),USERELATIONSHIP(Table2[Resolved], Dates[Date]))

    Here Table2 is my actual Data Table and Dates is my Date Table with All Dates

     

    Hope this solves your issue!!!

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi,

     

    The formula is great. Just a tip, it should be a measure.

     

    Best Regards,

    Dale

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
8 years ago

DrEvil,

For getting no of Issue Created, you will have the following

 

Category - Month

Value - Issue ID

 (The Above thing is already in place with you)

 

For Getting count of no of Issues Resolved, you the below calculated column

 

Count of Resolved IssueID = CALCULATE(COUNT(Table2[issue ID]),USERELATIONSHIP(Table2[Resolved], Dates[Date]))

Here Table2 is my actual Data Table and Dates is my Date Table with All Dates

 

Hope this solves your issue!!!

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi,

 

The formula is great. Just a tip, it should be a measure.

 

Best Regards,

Dale