Here, I have mentioned some of the real Interview Questions asked related to Power BI and SQL.
Power Query is the ETL component in Power BI where you can do a mashup of data coming from various sources and also do the transformation of data.
Answer – Create a bridge table having a primary key column from both tables and removing the duplicate. To make a unique column in each table by combining the columns and then connecting the table.
from(select version, product_oer_lvl_0_ID, mtd, dense_rank() over ( partition by version order by mtd desc ) as ranki
(select version, product_oer_lvl_0_ID, sum(mtd_net_amount) as mtd
AA_RPTG.OER_SUM Partition (OER_SUM_P_FORECAST_FACT)