save quarter value in a monthly cube

andreaLin.... · 2024-11-04T10:30:53+00:00

There was an error rendering this rich post.

Hi all,

I have a cube with a Quarter dimension, and I want to transfer the value to a Monthly cube, specifically in the last month of each quarter.
I tried with the dataflow but each month of quarter will be populated.
I hope you can help me

Andrea

Find more posts tagged with

Dataflow

Accepted answers

Helmut Heimann

Hi @andreaLin.... ,

you would need a cube structured by month that has a 1 for each month that is the last one in the quarter.

Example

In a dataflow you'd then multiply the quarterly values with this marker-cube into the monthly cube.

Result:

Best,
Helmut

All comments