Accumulate YTD

[nmhung49]

Hi everyone
I need help in this case
Now my dax only correct for not show Product column
For example as shown below
When I select Month = May => Product A => Acumulate = 19 and Product B => Acumulate = 27

Please see the attached file  

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but I think Product C also need to show accumulate number even it does not have sales in May.

I suggest having a proper dim-date table, assigning it as a date table, and having a one-to-many relationship with the data table.

Please check the below picture and the link down below, if it is what you are looking for.

Link to the sample pbix file 

[amitchandak · Accepted solution]

@nmhung49 , Few more changes are required. Please find the attached file after signature

Date Table, Use Date from date table in formula. Month and Year in Date table

[amitchandak]

@nmhung49 , Mark date table as the date table , Option on right click.

Create a new column for year in date table and use

Year = Year([Date])