How to get missing Months without a date column

[Kalyani22]

I have Table

T1:

Month, sales

Jan,300

Feb,500

May,600

] Now I want missing months march and April with previous month sales

[TauseefKhan]

Hi @Kalyani22,

SET vNull = NULL();

T1:
Load
Month,
sales
Inline [
Month, sales
Jan,300
Feb,500
May,600
];

AllMonths:
Load * Inline [
Month, MonthNum
Jan, 1
Feb, 2
Mar, 3
Apr, 4
May, 5
Jun, 6
Jul, 7
Aug, 8
Sep, 9
Oct, 10
Nov, 11
Dec, 12
];

Left Join
Load
Month,
sales
Resident T1;
Drop Table T1;

Apply sort by expression on Month field and use MonthNum field.

******Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.****