Forum Discussion
How to enter missing data into table
Super Usersaadat_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-query
Hi 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?