Solved

Mapping Values in different items

  • 6 July 2023
  • 2 replies
  • 94 views

Userlevel 2
Badge +2
  • Budding Pigmenteer
  • 6 replies

Any suggestion regarding oh how to complete the following:

I would like to allocate top value in the cells below.

 

In the Loss Utilisation Dash there is 1 metric more (Year Incurred)

 

The formula I used so far is:

'03. Future Taxable Income for utilization against available loss' [select: Year."FY 23"][by: -> '01.2 Year Incurred'. "FY 05"]

 

 

icon

Best answer by Mat 6 July 2023, 15:22

View original

2 replies

Userlevel 4
Badge +6

Hi @Rocco 

First Step: You need to Create a Year Property in your 01.2 Year Incurred Dimension and apply following Formula:  

item(if(CUMULATE(1,'01.2 Year Incurred') = if((CUMULATE(1,Year)-19) >0 , CUMULATE(1,Year)-19 ) , Year.'Opening Year'[Add:'01.2 Year Incurred'])[Remove Textlist:Year],Year)

Second Step: Apply following formula in 03.2 Loss Utilization Dash
 

'03. Future Taxable Income for utilization against available loss'[By:->'01.2 Year Incurred'.Year]

Hope Your Required View will be achieved in Table.

Hope, I have cleared your query.

Userlevel 3
Badge +4

Hi there Rocco,

 

I believe I have a solution for you that will fit what you’re after!

To get started, I would recommend creating a mapping metric where you can hold the mapping between the Year dimension and the Year Incurred dimension. This metric needs only to be dimensioned by Year, with a data type of Year Incurred as shown below:

Once you have this in place, you can then perform a simple mapping by using this metric like so: 

This demonstrates one of the nice uses of the BY: → mapping modifier. This is also quite flexible, as you can generate the values for the mapping by formula, or by manually defining the value - whichever one is more suitable to your business use-case.

 

I hope this helps, and please let me know if you need any further detail!

 

-Mat

Reply