Forum Discussion
WTD values not displaying correctly
Hi
I'm trying to put together a sales dashboard with WTD, MTD, and YTD figures, each displayed on a new tab. These would be split into each region ("outlet"), and by product type. Below is what I've currently got as my WTD table.
One of the issues I'm having is while the total figure at the bottom of the screen are correct, it's displaying figures that dont add up in the cells above/acrossfrom the totals? I've clipped the measure I'm using.
Sales WTD =
Var CurrentDate = MAX('Sales Data - 2021/2022'[Date Created])
Var CurrentWeek = MAX('Sales Data - 2021/2022'[Week])
Return
CALCULATE([Total Sales],
'Sales Data - 2021/2022'[Date Created]<=CurrentDate,
'Sales Data - 2021/2022'[Week]=CurrentWeek)
Then there are two more measures I have made that are below.
Total Sales = SUM('Sales Data - 2021/2022'[Sale Price Ext])
Week = 'Sales Data - 2021/2022'[Year]+(WEEKNUM('Sales Data - 2021/2022'[Date Created],2)/100)
If anyone has any suggestions and/or alternative ways to do this, that'd be great!!
Thanks
No RepliesBe the first to reply