Forum Discussion

IlseV's avatar
IlseV
Frequent Visitor
4 years ago
Solved

how to replace blank fields to zero in matrix visual

Hi I have a table Itemnumber      Date                    Value        A 12/09/2022 20 A 13/09/2022 50 A 14/09/2022 60 B 13/09/2022 40 B 14/09/2022 10 C 12/09/2022 ...
Help Request
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

     

    Hi,

    thank you for sharing.

    In my opinion, data model has to be created by using item dimension table and date dimension table.

    Please check the attached pbix file and the below picture.

     

     

     

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

     

    Hi,

    thank you for sharing.

    In my opinion, data model has to be created by using item dimension table and date dimension table.

    Please check the attached pbix file and the below picture.

     

     

     

    • IlseV's avatar
      IlseV
      Frequent Visitor
      4 years ago

      Wow, this works. Many thanks!

      I now added a Difference - measure to get a view on the difference in numbers between 2 days.

       

      I got the tip from another post:

      Difference = Var vPreviousDay = CALCULATE(Sheet1[expected measure:], FILTER(Sheet1,Sheet1[Days since]=MIN(Sheet1[Days since])))
      Var vPreviousDay1Back = CALCULATE(Sheet1[expected measure:], FILTER(Sheet1,Sheet1[Days since]=MIN(Sheet1[Days since])+1))
      RETURN vPreviousDay-vPreviousDay1Back
       
      But in the final matrix, I would in the lowest row expect -50 instead of +50, because I substract 0 minus 50.
      Do you have any advice on this matter? I add again the link to the pbix.
      Many thanks.