Forum Discussion

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
9 years ago
Solved

CRM DB

Hi, now my team is working on new project for the CRM SW CS Team. I realy need your help guys: 1. I would like to present in trend graph all cases created in certain month V closed cases at that m...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Noak,

    Please check if the attached PBIX file give your expected result.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Noak,

You would need to create measure by summing open case count and closed case count, then create viusals using this measure and month field in calendar table.

For your second requirement, please help to post sample data of your tables and expected result so that we can provide you appropriate formulas.

Thanks,
Lydia Zhang

Noak's avatar
Noak
Icon for Helper IV rankHelper IV
9 years ago

Hi Anonymous

 


"You would need to create measure by summing open case count and closed case count, then create viusals using this measure and month field in calendar table." - please provide function or explain.

Anonymous wrote:

Hi Noak,

You would need to create measure by summing open case count and closed case count, then create viusals using this measure and month field in calendar table.

For your second requirement, please help to post sample data of your tables and expected result so that we can provide you appropriate formulas.

Thanks,
Lydia Zhang

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Noak,

    Please check if the attached PBIX file give your expected result.

    Thanks,
    Lydia Zhang