Fill in date data

[Syndicate_Admin]

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

[Syndicate_Admin]

Worked perfectly, thanks

[Syndicate_Admin]

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

[PaulDBrown · Accepted solution]

This should work:

[PaulDBrown]

Can you provide sample data and a depiction of the expected outcome?

[PaulDBrown]

Try:

Poblacion =
CALCULATE ( SUM ( Table[Poblacion] ), ALL ( 'Calendar Table'[Month] ) )