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

Welcome Randy,

 

I generally use a CALENDARAUTO() table (DateData) in my reports.  In this table I create a "Week Starting" column (among others) with the following formula:

 

Week Starting = IF(WEEKDAY('DateData'[Date],2)=1,'DateData'[Date],DATEADD('DateData'[Date],-WEEKDAY('DateData'[Date],2)+1,DAY))

 

This gives me the Monday of the current week for each date.  I then join this table to my main data tables with the dates.

 

Let me know if this helps or you have other questions.

 

Brett