Forum Discussion
How to enter missing data into table
Hi,
I have created a datamodel. The model depicts a line chart with three lines:
FY23, FY22 and Target. The target is basically a percentage increased of FY22.
However, I have recently found out that the months July, August and September from FY22 showed data that was actually alot less than actual because some information wasn't recorded in the system due to a techinical problem. Normally in excel, I could just go into the cell for July, August and September and add in the missing values to the existing figures. How can I achieve that here?
Please note: I am using powerBI in direct querry mode.
2 Replies
saadat_rda , You have to correct the source and refresh data.
Or add new table with additional data and append it with the main table in the power query
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-queryHi amitchandak
Thank you for your response. I achieved a similar effect by adding the number to the measure I used to calculate FY22-previou year figures. The dax is as follows:
As you can see above, I added in the missing figures and this is what it looks like:
However, notice how the white FY22 line does not start from $0. Ideally, I want to add the three highlighted figures to the months July, August and September. If only there was a way to use the above dax but also use a function to filter the months July, Aug and Sep. Do you think this is possible?
