Forum Discussion

prabhuk's avatar
prabhuk
Helper I
5 years ago
Solved

Error in matrix table

Hello, can you help in identifing the error in the attached file. when i add reagion along with sales and commit table i am getting error. https://www.dropbox.com/s/yly9bouar7rjfz5/BI%20File.pbix?d...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Download the PBI file from here.

    Hope this helps.

parry2k's avatar
parry2k
Super User
5 years ago

prabhuk I know mahoneypat  gave the solution without a date table but I will never go that route Make a habit to add a date dimension in your model and perform all time intelligence based calculations based on this dimension. There is a reason why it needs to be in the model.

 

Just my 2 cents.