Hi Team,

I have a requirement of displaying dataset "MAQ GL Direct" with Month prior value to upload date for example if an individual has uploaded "MAQ GL Direct" table dataset on January-6-2023 then the column should say "Actual Dataset was refreshed for December Month". I have used nested IF condition(=if(Last Updated="January","December"....) but it take long time to calculate.

#ApptioforAll

I would use a table that has two columns. Last Updated and New Last Updated to replace your nested if statements. for example, Last Updated would be January, New Last Updated would be December. Last Updated would be February, New last updated would be January. Then just do a lookup off of this table to get your new last updated value

------------------------------
KristineKleinTerex CorporationSr IT Operations Specialist
------------------------------

Original Message:
Sent: 01-09-2023 11:05
From: Abhishek Dixit
Subject: Displaying previous Month for Actual dataset

Hi Team,

I have a requirement of displaying dataset "MAQ GL Direct" with Month prior value to upload date for example if an individual has uploaded "MAQ GL Direct" table dataset on January-6-2023 then the column should say "Actual Dataset was refreshed for December Month". I have used nested IF condition(=if(Last Updated="January","December"....) but it take long time to calculate.

#ApptioforAll

Thank you Kristine, can you advise if there is any formula other than creating a lookup table?
Original Message:
Sent: 01-09-2023 11:39
From: Kristine Klein
Subject: Displaying previous Month for Actual dataset

I would use a table that has two columns. Last Updated and New Last Updated to replace your nested if statements. for example, Last Updated would be January, New Last Updated would be December. Last Updated would be February, New last updated would be January. Then just do a lookup off of this table to get your new last updated value

------------------------------
KristineKleinTerex CorporationSr IT Operations Specialist

Original Message:
Sent: 01-09-2023 11:05
From: Abhishek Dixit
Subject: Displaying previous Month for Actual dataset

Hi Team,

I have a requirement of displaying dataset "MAQ GL Direct" with Month prior value to upload date for example if an individual has uploaded "MAQ GL Direct" table dataset on January-6-2023 then the column should say "Actual Dataset was refreshed for December Month". I have used nested IF condition(=if(Last Updated="January","December"....) but it take long time to calculate.

#ApptioforAll

Hi Abhishek, 

if you only want the month: you can format this as date for only the Month and then subtract 30 days - whenever you have a date in January'23 it would then say December'22. 
You should do this in the TBM Studio table and not in a report table.

basically the formulas would look something like this (in multiple columns for better readability - you can all combine this into one if you want to)

• Table Last Updated = DateFormat(TableInfo("Last Updated"), "M/d/yy")
• Days last Updated = Days(Table Last Updated)
• Display Previous Month = DateFormat(Days last Updated - 30,"MMM")

Hope this helps
Original Message:
Sent: 01-09-2023 11:05
From: Abhishek Dixit
Subject: Displaying previous Month for Actual dataset

Hi Team,

I have a requirement of displaying dataset "MAQ GL Direct" with Month prior value to upload date for example if an individual has uploaded "MAQ GL Direct" table dataset on January-6-2023 then the column should say "Actual Dataset was refreshed for December Month". I have used nested IF condition(=if(Last Updated="January","December"....) but it take long time to calculate.

#ApptioforAll

Thank you Jonas, this resolves my issue :-)
Original Message:
Sent: 01-10-2023 08:42
From: Jonas Koch
Subject: Displaying previous Month for Actual dataset

Hi Abhishek,

if you only want the month: you can format this as date for only the Month and then subtract 30 days - whenever you have a date in January'23 it would then say December'22.
You should do this in the TBM Studio table and not in a report table.

basically the formulas would look something like this (in multiple columns for better readability - you can all combine this into one if you want to)

• Table Last Updated = DateFormat(TableInfo("Last Updated"), "M/d/yy")
• Days last Updated = Days(Table Last Updated)
• Display Previous Month = DateFormat(Days last Updated - 30,"MMM")

Hope this helps
Original Message:
Sent: 01-09-2023 11:05
From: Abhishek Dixit
Subject: Displaying previous Month for Actual dataset

Hi Team,

I have a requirement of displaying dataset "MAQ GL Direct" with Month prior value to upload date for example if an individual has uploaded "MAQ GL Direct" table dataset on January-6-2023 then the column should say "Actual Dataset was refreshed for December Month". I have used nested IF condition(=if(Last Updated="January","December"....) but it take long time to calculate.

#ApptioforAll