Forum Discussion
Matrix visual, MoM values shown as zero (Power BI desktop)
I created the Relationship, DateTime[Date] to a_InitialData[OrderDate], 1 to many, single direction, and made sure the dates are of the same type (Short date)You mean the columns have the same data type or simply have the same format? Make sure they're both type date, no either type date or datetime.
That aside, the main reason you’re getting an incorrect MoM value is that you’re using one variable inside another while trying to change its filter context. Variables are immutable, so the first two variables will return the same results. Instead of reusing CurrentMonthValue in the second variable, use the SUM expression directly.
I created the Relationship, DateTime[Date] to a_InitialData[OrderDate], 1 to many, single direction, and made sure the dates are of the same type (Short date)You mean the columns have the same data type or simply have the same format? Make sure they're both type date, no either type date or datetime.
That aside, the main reason you’re getting an incorrect MoM value is that you’re using one variable inside another while trying to change its filter context. Variables are immutable, so the first two variables will return the same results. Instead of reusing CurrentMonthValue in the second variable, use the SUM expression directly.
Unbelievable! It was the VAR all along!!!!! Thanks!!!!