Nested Window Function

[Esef]

Hi All,

I am working on a complex semantic model where I need to do a cumulative total off of an offset window function measure. Essentially this would become a window function within a window function.

Is this possible? Has anyone done this.

The offset measure works fine but when the cumulative function that uses the offset measure is placed on the canvas it returns nothing.

Any help would be appreciated. 

[Ashish_Mathur]

Hi,

Share some data, explain the question and show the expected result.