Matrix with blanck values

[Anonymous]

Hi Power BI team , 

I am faced an issue :

I am showing assets under management for all month in selected year for each Fund.

I am using a matrix and a Calendar .

Filter Year and all month are coming from generated Calendra in Power BI .

My issue is I am getting Blanck values for some Funds ( especially Non financial fund as they have one or two max NAV per year) so for other months i have blanck value which is not correct as I need to put the last NAV <= current period

I am not able to use selected value in my measure to get <= selected period as i need to show a Matrix for all year ( from janueary to december) .

Do i need to use a cross join so that i can generate for eac calendar row a calculated Asset an dhow can i do it as i need to take the last NAV <= actual period if i have a blanck in my period .

Thank you 

[v-xiaotang]

Hi @Anonymous 

usually information below is needed, otherwise we are just guessing. could you provide it? Thanks.

 (1) a sample file, you can replace raw data with bogus data to protect your privacy.

     or provide some sample data that fully covers your issue/question.

(2) give your expected result based on the sample you provide. If calculation formula is involved, please provide it.

Kindly note: Please ensure the data in sample is concise and representative.

Thanks.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Yes, you need a cross join.  You cannot measure what is not there.

Please provide sanitized sample data that fully covers your issue.

Please show the expected outcome based on the sample data you provided.