Forum Discussion

Randyr's avatar
Randyr
Frequent Visitor
9 years ago
Solved

Grouping by Week Starting Date

Hello, I am a new Power BI user.  I am looking at Salesforce Live Chat Transcript cases and I am trying to count how many cases were created by week.   I have been able to do this by creating a new...
Need Help
  • Randyr's avatar
    Randyr
    9 years ago

    Thank you Angelia, I beleive I have it now.

     

    The problem was that I had to create a new column on my date table for "Weeks", then join the "Live Agent Created Date" field to that new column on the Date tab. Once I did that, it is now showing up correctly.

     

    Thanks again for the help!

     

    Randy

Randyr's avatar
Randyr
Frequent Visitor
9 years ago

Thank you Angelia, I must be doing something wrong as it is still not working for me.  The grouping looks correct.

 

 

Then when I drag the count formula in, it changes to this.

 

 

I appreciate any further suggestions you have.

 

Regards,

 

Randy

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi @Randyr,

Do you mind share your .pbix file forfurther analysis?

Angelia

  • Randyr's avatar
    Randyr
    Frequent Visitor
    9 years ago

    Thank you Angelia, I beleive I have it now.

     

    The problem was that I had to create a new column on my date table for "Weeks", then join the "Live Agent Created Date" field to that new column on the Date tab. Once I did that, it is now showing up correctly.

     

    Thanks again for the help!

     

    Randy