Forum Discussion
Percentage calculation between two different files and filterable by date
Schwurblini , Either remove Product from product name in table 2. have that first
New column in Table 1
Product Name = "Product " & [Product]
Create a common Date table and product Table
Product = distinct(union(distinct(Table1[Product Name]),distinct(Table2[Product])))
Join Date and Product Dim with with both tables and use them in visual, slicer and measures
Create a mesure like = Divide(Count(Table[Product Name]), Count(Table2[Product]) )
Super UserSchwurblini , Either remove Product from product name in table 2. have that first
New column in Table 1
Product Name = "Product " & [Product]
Create a common Date table and product Table
Product = distinct(union(distinct(Table1[Product Name]),distinct(Table2[Product])))
Join Date and Product Dim with with both tables and use them in visual, slicer and measures
Create a mesure like = Divide(Count(Table[Product Name]), Count(Table2[Product]) )