How to write DAX formula in power BI?
How to write DAX formula in Power BI? Step1: Select the Get data from other sources and click on it. Step 2: Click on the use sample data and click on it. Step3: Select and click on the load sample data. Step 4: Select and Click on the navigator financials. Step5: Select and click on the financials and load the data. Step 6: Select and click on the Data tab. Navigate to the home tab, select and click on the new measure. Step 7: Click on the cross icon and deselect all. Navigate to the home and select and click on the quick measure tab. Step 8: From the Select a calculation to create a measure option,select as average per category. From the base value option, select profit and mark as ticked from financial tab & drag to base value From the category option,select product and marked as tick from product.Click on the Add button. Formual shown will be appeared as below: Sum of Profit average per Product 2 = AVERAGEX ( KEEPFILTERS ( VALUES ( 'financials' ...