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 very much Brett, that new measure is now grouping the dates the way I want.  I am still doing something wrong though, if I add a visual table to look at the data, I group by the new measure I created.   "WeekStarting".  Then I created another measure to count the number of cases like so.

 

WeekGroup = CALCULATE(COUNT('Live Chat Transcript'[CaseId]),ALLEXCEPT(DateKey,DateKey[WeekStarting].[Date]))

 

Here is what I see....I think I have the count messed up somehow, it is not summarizing the number of cases by the new measure you gave me, it is totaling them.

 

 

 

Here is the way it looked before.

 

 

Thanks again! I appreciate any help you can provide here.

 

 

  • bjnodello's avatar
    bjnodello
    Helper II
    9 years ago

    Can you check the direction of the date relationship?  I have mine set to "Both".

    • Randyr's avatar
      Randyr
      Frequent Visitor
      9 years ago

      Thank you, yes it is set to 'both' now but no change i'm afraid.

      • bjnodello's avatar
        bjnodello
        Helper II
        9 years ago

        Can you explain what you are trying to do with the ALLEXCEPT filter?