Forum Discussion
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...
prabhuk for any date-related calculations, you must add a date dimension in your model, and to add one, you can look at my post here.
once this table is there, change all your measures to use date from this new date table instead of from your sales table and it will all work.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡