Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago
Solved

Measure not producing proper result in Matrix table

enclosed is a workbook   i am trying to create a Matrix that shows the difference between current month and previous month. i am having trouble with the calculation.  if I use a 'card' i can select...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    ilcaa72,

    Please use Date format instead of Date Hierarchy format in Matrix Column.  Measure returns incorrect data due to the Date Hierarchy.



    Regards,
    Lydia

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago

hi Lydia,

 

i created a index in power query.  If i change the "Sort by", for date to Index in PBI, the values change.  here is a screenshot and the workbook, thanks for the help.  i cant figure it out!  https://1drv.ms/u/s!Av69y58QJYzRjyK7uV29mJleakUo