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.
Hi, I am very ameature in finding mistakes. Look at the Adjustable Race and Chain, no value is showing here. I've given you the link of this file https://1drv.ms/u/s!AtNgJBWI0wXOddMheymYlp08Ci0. You'll find it in Best Selling page. Please help me to find out the mistake.
Not really a clean way, no. The easiest thing to do is make sure that all DimProduct entries have a ProductSubcategoryKey that can map to DimProductSubcategory table.
This is Adventureworks DW SQL Database. This is the limitation.
Is there any way to fill up this blanks using a calculated column?
It's because the 'DimProduct'[ProductSubcategoryKey] is empty for some entries. The DimProductSubcategory table must have the blank row added to it. All the records from the DimProduct table that do not have a ProductSubcategoryKey map to the blank row in the DimProductSubcategory table.
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |