Extrapolate The Results of Missing Month Data

DAX
1

I am facing a challenge. I need little help.

I have two Tables (Dates Table & Sales Table)
Sales Table has following columns:-
Supplier/Company Name, Qty, Sale Price, Sale Amount etc.

Sales Table comprises of 5 years (2017 to 2021) of sales data , but the Dec-2017 data of competitor companies is missing.
However, my company’s data for Dec-2017 do exists. hence i am unable to make a like with like comparison.

In Excel, i was simply extrapolating competitors’ results of 2017 by dividing by 0.917 or 11/12.

The question is, how can i do it in DAX or Power Query?

Plz guide !

2

Hi @Jawad -

If it is for single row, then better option will be to add it manually to the Sales table using Table.InertRows functions as below.

# Table.InsertRows

If it is for Multiple Rows, then create a new table manually or by sourcing through excel with missing rows and append to the existing sales table using Append Rows option available on Power Query Editor.

Thanks
Ankit J

1 Like
3

Also check out Data Mentor for this

1 Like