Calculation to take last not empty value

[philelmousse]

Hello,

I have a measure which should be filled by the last not empty month. My model is based on a star schema, I created my dimension and measures. I have a dimension time with the month and the year. There is a prompt to select the month that the user want to display

Ex : if February value is '150' then display '150', if March is empty then apply '150'

How manage that ?

Thanks

[cognostechie]

Create another query subject and use the max function in conjunction with a filter to exclude the empty rows so that it retrives only the the last month which has a value.

Join this query subject to your original query subject with 1:1 relationship.

In the Model Query subject in the Business Layer, bring the column and name it 'Last Month with Value'.

In the report use a calculation like:

If Month is null then Last Month with Value else Month