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...
lucadelicio
Impactful Individual
Impactful IndividualIt's more easier to help you if you upload your pbix.
Also image of the relationship and the image of the table.
You can try to report the single data in every table with a calculated column.
Then create a data table (with all the day of all the year present in the other table).
Then use it like a slicer to select and filter the divide measure to calculate the result.
I hope I have been helpful.
Mark it as a solution if resolve your problem.
Ciao!