Forum Discussion
Need Help on deciding DAX
Hello Guys, I am working on PowerBI for the project of Sales automation, and I am directly connected to live data ( ERP is AS400), after data transformation and data modeling when I am trying to crea...
This is my data model I want to calculate sales value based on GL year 2022 and 2023, and GL period 1 to 12, INLNYR, has invoice date, sales value information, INHDYR has GL period, GL Year and ARSLSM has Sales Rep information. I dont know which DAX should I use to extract this information.
SidraB i dont know your knowledge of dax, but all those many to many relationships are very dungerous, very hard to follow the numbers/validations. I would start by "trying" to convert most if not all things, into many to 1 relationships.