aggregate table

[refint650]

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 includes only selected columns(5), measures(2)  any approach in Power BI we could accomplish  without re-writing sql . so i can write few  conditional calcuations on aggregate table.

SQL syntax

Select A1, A2, A3, A4, A5, sum(actuals) as Actuals, Sum(forecat) as forecast  where A1 = "Y" and A3 ="N" Group by A1, A2, A3, A4, A5.

Thanks

Vs

[amitchandak]

@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

[refint650]

@amitchandak 

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.?