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

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?

      • bjnodello's avatar
        bjnodello
        Helper II
        9 years ago

        Not a problem, I'm by no means an expert.

         

        Here is what I believe the ALLEXCEPT clause will do.  In the case where you have a date slicer, if you filter by a specific day the count will include the count for the entire week.  If your count does not inlcude the ALLEXCEPT clause your count will only include the records for that specific day.  

         

        For the example below:

         

        WeekGroup = CALCULATE(COUNT('Data'[ID]))

         

        WeekGroup2 = CALCULATE(COUNT('Data'[ID]),ALLEXCEPT(Data,Data[Week]))

         

         

        There is a single record for January 3 and 4 records between January 2 - 8.

         

        Do you know how you will be filtering and how you want the data to respond?