Currency Conversion: Different Booking Date for different Account Elements

eric2357 — Thu, 02 May 2024 07:26:12 GMT

Hello Community,

I am using a New Model with an Account Dimension, one Measure and one calculated Measure. In the Account Dimension, I am using two key figures, for one of them I have to use the booking date as the reference, for the other one I am using Booking date + 1 month.

It is possible to realize this with 2 converted measures, one for each key figure. But this leads to problems in the table in the story, if I want to show both key figures in one table.

I want to display it like this:

	Converted Measure
Key figure 1	12
Key figure 2	10

But currently, it looks like this:

	Converted Measure 1	Converted Measure 2
Key figure 1	12	13
Key figure 2	9	10

So my question is whether it is possible to make adjustments to a single Account Element? Or is there a different workaround?

Thanks you!

Kind regards,
Eric

Re: Currency Conversion: Different Booking Date for diffe...

N1kh1l — Sun, 05 May 2024 07:53:41 GMT

@eric2357

Booking date can be set per converted measure and not per account so you will need 2 converted measures set with 2 booking dates. Unfortunately there is no way to provide account filters in this calculation.

Re: Currency Conversion: Different Booking Date for diffe...

eric2357 — Mon, 06 May 2024 07:00:52 GMT

Okay, thanks for your answer!

Question Re: Currency Conversion: Different Booking Date for diffe... in Technology Q&A

Currency Conversion: Different Booking Date for different Account Elements

Re: Currency Conversion: Different Booking Date for diffe...

Re: Currency Conversion: Different Booking Date for diffe...