Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Issue Cumulative Sales based on Week

Hi guys,   i am worried about the issue that i had couple days ago and today is my deadline to deliver a report.   Well lets start by explaining the used measures:   Total Revenues = SUM('Sale...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
tex628's avatar
tex628
Community Champion
7 years ago

Create a week column in you datetable: 

Week = WEEKNUM(Calendar[Date];2)

Use it instead of the "Week of Year" column that you are currently using or do you have to use a week column that is outside of the calendar table?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey it still doestn work...

it still give me the same amount of 45 mil on every row based on your suggested calculated colum in the same date table.

 

I  dont bother to use a a week column inside or outside  the table

  • tex628's avatar
    tex628
    Community Champion
    7 years ago
    Dim Calendar Sales Invoice [Date] and Dim Calendar Sales Invoice [Week] are both in the same table and it still doesn't work?

    Shouldnt be possible...

    Can u pull both date and week into the matrix and take a picture?
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      • tex628's avatar
        tex628
        Community Champion
        7 years ago

        And with the amount measures in the matrix aswell!