Forum Discussion
Combining data from 2 tables with different date granularity
Hello, I want to calculate the weekly rotation (=rate of sales) of products sold per store. To do that, I have two tables: - Total sales of specific products at a particular retailer. Each entr...
Hi,
Create a Calendar Table with calculated column formulas for Year, Quarter, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag Year and Quarter from the calendar Table. Write these measures:
Qty sold = sum('Sales'[Quantity sold])
Dist = sum('Distribution'[Quantity])
Hope this helps.