Forum Discussion

Post Partisan

7 years ago

Need to use If Condition In Power BI Desktop.

Hi Team, I want to establish If condition in power bi which I have made in excel i.e, =if(Profit > Average Profit/Employee , Profit, Average Profit/Employee). So how I can make that type of form...

Post Partisan

7 years ago

Now the total issue fixed but the average is not correct. There are 17 AM's and the total profit is 279384.88.

Then The average is 279384.88/17=16434.40. But in your case the average display as 173.85 which is not correct.

Please find the attached.

Thanks,

Arvind

Post Partisan

7 years ago

Have you got any solution?

Thanks,

Arvind