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
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