Hi everyoneI need help in this caseNow my dax only correct for not show Product columnFor example as shown belowWhen I select Month = May => Product A => Acumulate = 19 and Product B => Acumulate = 27
Please see the attached file
Go to 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
View solution in original post
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
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Best regards, JiHwan Kim
@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])
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.