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

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