About jjayavalli

I Got the answer for the above question. After adding formula to the Code, it will populate code value. ... View more

Hi Can you let me know how you solved it? Thanks ... View more

So creative, the piece I was missing, thank you! I added this Calendar to a list dimension to calculate a few at a time for different dates (and use a few year Time Range on this model to limit the daily module size) and lookup my current reporting period to pull a set of business dates for this period. I can then save the resulting business dates each month/quarter to a module without the daily calendar calcualtor. One small edit in case anyone else tries to replicate - Holiday Day Ref needs to read "If Date Range AND Holiday THEN 1 ELSE 0" otherwise you end up adding all of your holidays over the periods to every date's adjustment. Thank you again! ... View more

Congratulations! I believe you should become a Model Builder to get the certificate. Thank you ... View more