Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Calculating %'s from previous months data

Hi, using the data below, I need to show:   -  Each Issue % change from the previous month. For example    Aggression: from Jan to Feb =  100%. Feb to March = 75%    Missing People: from Jan to F...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi RichOB,

     

    When we want to calculate the number of incidents for a particular Issue and Date combination, we do not need to sum any field. Instead, we should count the number of records (rows) that meet the relevant conditions.

    In the original DAX formula provided, where SUM('Table'[Value]) was used, it should be replaced with COUNTROWS('Table'). This function will correctly count the number of rows (incidents) for each Issue and Date, allowing you to then calculate the percentage change over time.

     

    I hope this helped! Feel free to ask any further questions. If this resolved your issue, please mark it as "Accept as Solution" and give us Kudos to assist others.

     

    Thank you.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi RichOB,

 

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

 

Thank you.

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

Hi  RichOB 

 

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a valued member of the Microsoft Fabric Community Forum!