Forum Discussion
combining 4 data sources
Hello All, I have 4 files 1. Open Orders (only data from Aug Sep Oct) 2.Current Month (only Aug data) 3. Completed Transaction (Jan-July data) 4.forecast(Oct Nov Dec) all 4 above files have pa...
You should review this article Append queries - Power Query | Microsoft Learn and append all your tables using Power Query, then create a calendar table with columns: Date, Month, Month Number, Year, etc.
Relate it to your combined table using the "Month" field.
Set a one-directional relationship (from the date table to the merged table). Then, create a dynamic measure to handle the special logic for August.
Sorry my bad, Months were stored in single column, appending will work