Forum Discussion
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...
Hi,
thanks for your quick response.
Your measure works when i visualize this:
But my wish is to make a chart where the following result without using column Date:
unfortuantly you see that the amount of 45 million comes on every row....
any suggestions ? thanks
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?
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
- 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?