how to get the last year last quarter last month last week last day sales in single Measure Object

[former_member302018]

Hi guru,

today i faced one question interview.

the requirement is

how to get the last year last quarter last month last week last day sales in single Measure Object.

Please guide me guru

Thanks

Manohar

[former_member207052]

The question is not very clear.

Do you want the previous year, previous month, etc values for ANY given date OR you just want the latest (last) available data for year, month, etc?

Regards,

Naras

[former_member211235]

Hi,

If you have all the time dimension objects in place then you get all together using Last() and concatenating all the objects into one measure else create all the individual time/calendar objects and use Last function on top of them and then finally concat them.

Grtz

-Anila.

[guillermo_m]

Hi Manohar,

You can use the LAST formula to achieve that.

=Last([Date dimension]) ForAll ([Measure])

If you need somenthing more complex, i.e. get the last month of the year where a sale has been made you could use...

=Last([Month dimension]) Where (Not(IsNull([Measure])))

I hope this helps you.

Cheers!