Forum Discussion
Time Series Analysis
Hi, As per below I want to split the total spend for the year which is selected in filter to split it into Qtr's how can I acheive that? MaxyearAmount1 = CALCULATE([Spend],FILTER(ALL('Date'),...
I don't get what are you asking, but as per below image I want MAX year spend split into Qtr's, If any Qtr doesn't have any spend then it should be showing blank instead of removing row for that Qtr.
As you see in below image that date filter is removing the row
Enable "Show items with no data"