Forum Discussion
Fill in date data
Hello everyone
I need help in something that has me stuck. I have a table appended to PowerBi using Direct Query with dates and data. The data are annual but in the table they only appear for a specific day (January 1 of each year). In Power BI, I relate it to a calendar table than other sources; when selecting by month I only get data in January, and if I select another month the result is white (the data is a sum measure). I want the January data to be displayed when I select any month of the year.
Thank you
This should work:
5 Replies
Try:
Poblacion = CALCULATE ( SUM ( Table[Poblacion] ), ALL ( 'Calendar Table'[Month] ) )It didn't work for me. The data in the original table only appears every January 1, then in power bi I want to see the data at the monthly level, and that it is repeated during all the months of the year. I don't know if I explain myself.
Thank you
Can you provide sample data and a depiction of the expected outcome?
This should work:
Worked perfectly, thanks
