Forum Discussion

laraibashfaq's avatar
laraibashfaq
Regular Visitor
4 years ago

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

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

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

  • laraibashfaq's avatar
    laraibashfaq
    Regular Visitor
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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