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