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'),...
Need Help
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 

 

 

 

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Enable "Show items with no data"

  • 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