Forum Discussion

Mario_Archontis's avatar
Mario_Archontis
New Member
8 months ago
Solved

Matrix visual, MoM values shown as zero (Power BI desktop)

Hello all. I have been dealing with this glitch the whole day and neither chatGPT nor Gemini could solve it. Ok, so I have a dataset (a_Initial_Data) with an Order_Date (Date type) column and a Rev...
Need Help
  • danextian's avatar
    danextian
    8 months ago

    Hi Mario_Archontis 

    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.

Mario_Archontis's avatar
Mario_Archontis
New Member
8 months ago

amitchandak thanks for the quick reply! Sorry if I do not reply sufficiently on your suggestions, but I am new to this. Anyway,

I do not need join date (extra table with unique dates) but without it (relying on 'a_Initial_Data[Order_date] I failed again.
I need Month to Month for the same year. The dataset is only for 2023.
I do not understand MTD (probably MonthToDate?). If yes, no need also.
I will try with inactive join...