Aggregated Table in Power BI Using GroupBy Function in DAX

There are many different ways you can create aggregations in Power BI, You can do it in the source (using the database t-SQL language), or using Group By operation in Power Query. You can also do it in DAX using some functions. One of the functions that can be used for grouping and aggregation is Group By. This video is about how to use Group By in DAX. Creating aggregation using DAX is a very useful skill because you can use it to create virtual tables in your measures and have better dynamic calculations in Power BI.
Download the file and read more from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

[ilikedigitallogic]

You know I took a long time for find video for introduce create aggregated table by DAX. Thank you so much

[totvabe]

Great! The 2nd example has been fantastic because after the 1st I was struggling in how do it with a measure.
Thanks!

[telmanmaghrebi]

Amazing Explanation! Really appreciated!

[yourfisfake]

Great work! Really helped me in my work. Thanks

[mahsanaji]

Is there a way to translate the following sql query in power bi?
select
case
when ave x then y
else z
end as AnotherColumn
from
(select column1, average(column2) as ave
from table
group by column1) t

[abdulqadeerkamangar]

In first example can we use and top 5 by count?

[saqlineahmed]

Can you please put a video on how to convert existing columns into row headers using dax not with pivot option...