Forum Discussion
Calculate Column based on another table without relationship
Hi guys, I'm beginner in Power BI and need help. I need a DAX column with my customer list that will show their sales in the slicers based on the year and item group selected from the sales dat...
The formula should be correct. Please make sure you're using the correct columns
Please see attached pbix for your reference.
PS: this would have been simple had you used relationships.
Thank you danextian. Yeah the DAX works now using the sales table 🙂
But is this doable in the Customer Master table? In my main file, I need a DAX that displays the sales scenario for my Customer master. I know relationship can simple do this, however I need a DAX formula because relationship is no longer applicable in my main file.
I would appreciate it if you could continue to assist me 🙂