Show total month sales every day for current month with dynamic year and month slicer

[key1012]

Hello, I want to show the total previous month sales value for everyday, with day on x-axis, and update dynamically when year and month slicer is chosen. 

I have a calendar table. (1-to-many relationship to "Reporting Date" in inventory table as below)

I have a inventory table, with each month's inventory appended  every month, with a month-end column "Reporting Date". 

ex)

If today = December,

November inventory = 100 units,

In bar chart, I want to show 100 units for each day (1,2,3,4,5.. 31) when month slicer is selected to December. 

If today = January, I want to show December inventory... you get the drill.

Please help how i can make this calculated measure ! and if i need to change my Reporting Date relationship, please let me know!

Thanks!

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Inventory measure: =
CALCULATE (
    SUM ( Inventory[Inventory] ),
    'Calendar'[Date] = EOMONTH ( MAX ( 'Calendar'[Date] ), -1 )
)