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 have have a data table with sales results of Region, Product, Date (only monthly needed) and a Quantity.
I would like to automatically add rows for all Region/Products where the month is missing with Quantity 0. E.g. from DACH and Product M I am missing June as well as Aug - March, so it should add 9 lines with DACH, Product M, missing and so on for the other region/products.
As a result:
Reason is that I want to add a calculated column for the forecast later on, and this might add quantities to the missing month. If I do not have all 12 month line I am missing numbers.
I know ... does not sound very professional but i do not know better yet, being under time pressure.
Instead of the month I have a calendar date as well, connected to a date table ...
Any feedback appreciated
Thank you
Robert
Solved! Go to Solution.
Hi,
You can achieve this
starting from this
by applying the steps of the attached file
If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!
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.