Forum Discussion
Create Rows to the table where the data is missing for specific dates
Hello All, I have a table with below columns in my dataset. We have monthly revenue for each resellers in this table from feb-21 to mar-22. For few resellers, there will be no data for ...
Hi Shishir22
I actually want to create rows in the table where the data is missing for particular month. it should show all the dates(feb-21 to mar-22) for all the customers with the revenue as blank whereever the date is missing for the customers
Can you please try above steps.
It should show expected result.
Thanks,
Shishir