Need Help : SSAS DAX Expression

[SantoshKumarS]

Hi Team,

I have a DAX requirement in SSAS Tabular Model.

DAX Expression used:

Last Week Quarter Bucket =
CALCULATE(
LASTNONBLANK('Account'[Quarter Bucket],1),
FILTER('Account', 'Account'[Week Bucket] = "-1")
)

Based on the above DAX Expression, i am getting the result as in Column D. Can someone help me with the DAX Expression to get the resultset as per Column E.

Result Screeshot:



Thanks

Santosh

Continue reading...