Skip to Content
0
Aug 04, 2023 at 01:18 AM

YoY formula clarification

109 Views

Hi All,

I am trying to put a YoY calculation in Model so that it is available on all stories. I came across the below formula

Lookup([USD],[d/Time] = Current (“Year”). Current (“Quarter”))

I was able to get the USD and Time in my formula as they are measures and dimensions in my model. However I am not able to figure out how to get "Current", "Year" and "Quarter".

Any advice on how to build the formula??

regards

Vish