What's the best way to show the total number of employees per branch per month and year in Power BI? I think I need to use the sum function with a group by with a date filter but I don't how can I use Group BY in DAX Power BI.
Current Table is
In Power BI, you can perform Group BY using Power Query without using DAX function as the following:
Home
Transform Data
Power Query
Queries
Group By
Transform
Advanced
Ok
See also How to use Power BI DAX CALENDERAUTO?
817 questions
541 answers
405 comments
190k users
Related Activities
Most popular tags
deBUG.to Shortcuts
Categories