Author Topic: Calculations for relative time  (Read 231 times)

Offline Cognosnewbie26

  • Full Member
  • ***
  • Join Date: Jul 2020
  • Posts: 9
  • Forum Citizenship: +0/-0
Calculations for relative time
« on: 02 Sep 2020 12:24:50 am »
Hi,
My time dimension looks like below:
Year
Quarter
Month
Date
I want to create a calculation for Prior Time ( it can be prior year, quarter, month or same date of previous year)
I was wondering if I can create a calculation in such a way that it is able to gauge  if it is a year, quarter, month or date is pulled for the current year
For e.g
                           Month     PYMonth
Account No

In the above case if I pull the 'Month' then it should be able to calculate the amount for the PYMonth


« Last Edit: 02 Sep 2020 10:19:56 am by Cognosnewbie26 »