I would like to create a series of measures that shows my current week's sales by day. Example: 1 measure shows Sunday's sales, 1 measure shows Monday's sales, etc.
In order to identify the current week, I have added a field to my date table called 'Week Rank' in combination with the max function.
When I use the below formula, I get a very wrong answer. Trying to figure out what the figure is, but no luck so far. What is wrong with my formula?
Sunday Sales = calculate(sum('Transaction_Data'[TotalSales]),filter(all('Dates'), Dates[DayOfWeekName]="Sunday" || Dates[Week Rank]=MAX('Dates'[Week Rank])))
In order to identify the current week, I have added a field to my date table called 'Week Rank' in combination with the max function.
When I use the below formula, I get a very wrong answer. Trying to figure out what the figure is, but no luck so far. What is wrong with my formula?
Sunday Sales = calculate(sum('Transaction_Data'[TotalSales]),filter(all('Dates'), Dates[DayOfWeekName]="Sunday" || Dates[Week Rank]=MAX('Dates'[Week Rank])))