Dealing with change over time function

[jleefjcapital]

Hello,

I was able to create a master measure item to compute the period over period growth, but the problem is when I try to show the most current growth value, I need to select both dates otherwise the value is null.  I can understand why this is happening, but is there a way around this? 

Thank you,

Jessica

[sunny_talwar]

Awesome

Anything else we need to work on?

[jleefjcapital]

yes, do you know how to reduce the trailing decimals in the variables?  Current the output values have trailing decimals to the 6th place.   I know there's a trim statement, but I'm not sure where to use it. Would I need to create a measure for each variable? 

[sunny_talwar]

Reduce this? 21.942353 You can use Round(21.942353, 0.01) which will give you 21.94

[jleefjcapital]

should I use that in the load step? 

[sunny_talwar]

You can if you want to round the numbers when you bring them, but the downfall is that you loose precision of decimals in your application. If precision is not important I would drop them off, if it is, I would use front end formatting to see only two decimals (if that is what you want) using Num() function

Num(21.942353, '#,##0.00') will give you 21.94 -> benefit is you still have the precision

Best,

Sunny

[jleefjcapital]

So I would need to create a measure for each of the variable?   Cool!

Thanks,

Jes

[sunny_talwar]

Hahahaha, seems like you got your solution, did you??? I am kind of confused about what exactly are you trying to do? If you know what you want know, you don't have to spend your energy explaining it, but if you still need help, I would like if you can elaborate

[jleefjcapital]

Yes, sorry for the confusion.      Thank you again for all your help!  Actually, the change function also works.  It was my error. 

[jleefjcapital]

Thank you, but I have already been helped.  Have a great day!

[sunny_talwar]

No problem

Have a wonderful weekend.

Best,

Sunny