Forum Discussion
dax formula
I have one data set there columns like DATE, CATEGORY, SUBCATEGORY, and Planned unit.
so I have to take cumulative Planned unit category wise (Running sum Category wise ) but before that what I want, I have to group by all SUBCATEGORY. BECAUSE UNDER the 1 category I have a lot of #subcategories, THAT I don't want,( i mean after grouping that planned unit column should sum based on group by)
how can we group by subcategory in Dax without losing the other column?
1 Reply
Hi ukantkumar ,
Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Regards,
Daniel He
