Affine Power BI Developer Interview Questions and Answers

I have worked on various types of data sets including sales data, customer data, financial data, and social media data.

• Sales data

• Customer data

• Financial data

• Social media data

Calculate delta sales growth using DAX formula

• Use the following DAX formula: Delta Sales Growth = (SUM(Sales[SalesAmount]) - CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))) / CALCULATE(SUM(Sales[SalesAmount]), PREVIOUSMONTH('Date'[DateKey]))

• Make sure to replace 'Sales[SalesAmount]' with the actual column name in your dataset

• Ensure that 'Date'[DateKey]' is the date column in your dataset