cancel
Showing results for 
Search instead for 
Did you mean: 

Currency Conversion: Different Booking Date for different Account Elements

eric2357
Explorer
0 Kudos

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 112
Key figure 210

But currently, it looks like this:

 Converted Measure 1Converted Measure 2
Key figure 11213
Key figure 2910

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

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor

@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.

 

eric2357
Explorer
0 Kudos
Okay, thanks for your answer!