Time Dimensioned Data to No Time Dimension (Last Non Blank)

Options
sonpatel
sonpatel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi Community, 

 

I am trying to take data that is dimensioned by two lists and time to a module that is only dimensioned by one of those lists and no time. 

 

Module 1:

           Dimensions: List 1, List 2, Time

           Line Item: Formatted as a month and calculates Start Date and has it show up for the month that it is in (ex: Feb 20 is start date so in Jan 20 the line item will show blank but in Feb 20 the line item will show Feb 20 and in March 20 it will be blank); formatted to be a last non blank summary

 

Module 2: 

           Dimensions: List 1

           Line Item: Is formatted as a month and SHOULD bring in the month that is not blank / is populating in Module 1 but I am not able to get this to populate. 

 

QUESTION: How do I get the line item in Module 2 to populate with the month that is populating in Module 1? 

 

Please let me know if you have any suggestions/ thoughts or if I provide any additional details. Thank you! 

Tagged:

Comments

  • sonpatel
    sonpatel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi Rob! 

     

    Thank you for taking the time to help me with this. To help answer your questions: 

     

    • List 2 does have a top member defined 
    • The summary of the line item in module 1 is last non blank. 
    • In time we do have all periods defined 

    I ended up using a select and was able to get the result I needed but curious on your thoughts on the pros and cons between the two solutions? 

     

    Thank you!

  • sonpatel
    sonpatel Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
    Hi @jziemer!

    Thank you for taking the time to help me with this! Is there a reason why you believe Rob's solution to be more efficient than using a select? Is it solely on the basis that using a select is not recommended?

    Thank you!

Categories