Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
So I essentially have a list of Retail Locations in power Bi that has sales data on a per location basis. The problem is we are trying to combine a manual source of data which has thousands of rows of data with an OLAP Cube Query. I originally was going to try and merge the Olap Cube data to fill in the 'null' values inside the manual data table, but this doesn't work the way I thought. Does anyone have a way I could write some DAX or M or MDX to recombine these values matching on like time and location and the name of the metric to build out this table? Thank you so much for anyones time i really appreciate it!
Hi @Brando6,
What's the way you expected? Can you share a sample of your data?
There could be some possible solutions.
1. Replace the NULL values with other values first.
2. Merge with more than one column criterion.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
119 | |
107 | |
69 | |
68 | |
43 |
User | Count |
---|---|
148 | |
104 | |
102 | |
89 | |
66 |