Hi,
I have a pivot table on sales data (customer name, date, revenue) and also created a calendar table.
I have a relationship between both tables on the date.
When trying to calculate YTD however I just seem to get (Blank) and I have no idea why!
Measure used is: TOTALYTD(sum(Sales_table[sales]), 'Calendar'[Date])
Would really appreciate it if someone could show me where I am going wrong!
Thanks
I have a pivot table on sales data (customer name, date, revenue) and also created a calendar table.
I have a relationship between both tables on the date.
When trying to calculate YTD however I just seem to get (Blank) and I have no idea why!
Measure used is: TOTALYTD(sum(Sales_table[sales]), 'Calendar'[Date])
Would really appreciate it if someone could show me where I am going wrong!
Thanks