Time Series Analysis

[laraibashfaq]

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'),'Date'[Year]=MAX('Date'[Year])))

@amitchandak 

[laraibashfaq]

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 

[Anonymous]

Hi @laraibashfaq ,

What's your expected result? Whether the below table data with green square is what you want? Could you please share some sample data with Text format(exclude sensitive data) and your expected result with calculation logic and special examples in order to provide you a suitable solution? By the way, it seems that there is a date dimension table in your model, is there any relationship created between date table and fact table? If yes, please also provide the related relationship info. Thank you.

Best Regards

[lbendlin]

Enable "Show items with no data"

[lbendlin]

what is the weight for each quarter?  Classic 4x25, or some shifted values like 22-24-26-28 ?