Forum Discussion
How to show negative value (infinity)
Anonymous I know what COGS is but my question was, is it a measure? if yes what is the expression, are you getting the value in COGS tables, for debug purpose, visualize if you are getting cogs values and go from there.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Anonymous what is COGS, can you make sure there is value in COGS when you are switching to SQL
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
parry2k COGS is Cost of Good Sold yes that also moved to SQL and relationship is also active.
Anonymous I know what COGS is but my question was, is it a measure? if yes what is the expression, are you getting the value in COGS tables, for debug purpose, visualize if you are getting cogs values and go from there.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
parry2k you are right. the issue was in COGS Date Relationship was not working.
Thank you for your support.