Forum Discussion
Solved
Group data with DAX
Hello good morning, I would like to know if with DAX you can do a grouping of values as you would in Power Query with the grouping itself (I ask this because I can't edit Power Query queries), or...
Syndicate_Admin , a measure like this can help
maxx(summarize(Table, Table[mater_product_id], "_sum", sum(Table[num_promos])), [_sum])
You can create a table if needed using summarize or summarizecolumns
summarize(Table, Table[mater_product_id], "_sum", sum(Table[num_promos]))
Syndicate_Admin , a measure like this can help
maxx(summarize(Table, Table[mater_product_id], "_sum", sum(Table[num_promos])), [_sum])
You can create a table if needed using summarize or summarizecolumns
summarize(Table, Table[mater_product_id], "_sum", sum(Table[num_promos]))
I thank you for your answer, sorry if the question is very basic but I am very new, one more doubt I would have is if that calculation is affected by a date slicer.
