Forum Discussion
aggregate table
Hi My report has SQL detail table with 20 columns, 2 measures (actuals, forecast) for detail Power BI reporting . I have another scenario where to build aggregate custom table which include...
refint650 , Group by in power bi, Summarize and Group by in DAX
https://docs.microsoft.com/en-us/power-query/group-by
You have to create measures again
refer for examples
https://amitchandak.medium.com/power-bi-power-query-vs-dax-append-and-summarize-data-233f173d0839
Aplogigze for foget to say it's direct query connection, so do not have option of M query, can i pick select column function to achieve.?