Operations with values of current and previous month ..

[Khalilo]

Hallo ..

having a kind of cross table with a simple Measure and 2 dimensions.(Month and Color).

i am triying to dynamically calculate the ratio of Amount between month x and month x-1 trough all table cells (see Attachement). Any idea how to realize this ..?

Regards

[Lothar_Köder · Accepted solution]

Hello Mohamed,

If you use a acquired model with month as date dimension you could work with a calculated metric of type "Difference from" as well:

Looks like this at the end:

Best regards

Lothar

[Khalilo · Accepted solution]

a small detail in this regard. ths reason for missing option of "Difference from" was an incompleted configuration of time Views ..
If you use standard Time Views in DWC then no need for any action. Otherwise if you use own Time Views then all associations should be configured exactly as native ones ..

[Khalilo]

Thanks for the answers ..

@Lothar .. Correct this would solve it.

But for or an unknown reason this calculation type "Diference from" is not displayed for the DWC Model we are using (obviously not available for each and every model )

[William_Yu]

Hi mokatif,

You need two cross calculations/calculated measure:

1. Restricted Measure with Month -1 : restrict on time dimension -> navigation 'Last Month'
2. Calculation Measure: standard measure / month -1

Best regards, William