Forum Discussion

arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost 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...
Need Help
arvindyadav's avatar
arvindyadav
Icon for Post Partisan rankPost Partisan
7 years ago

Hi MFelix,

 

Not works. For every month and individual month, the total is the same.

 

Please find attached.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

Hi arvindyadav,

 

Is you tabel setup as the one you gave me on the example file?

 


Regards,

MFelix

  • arvindyadav's avatar
    arvindyadav
    Icon for Post Partisan rankPost Partisan
    7 years ago

    No

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi arvindyadav,

     

    As I refer this calculation are based on context so if your model setup is different then the final result will not match what you need.

     

    Can you share a mockup of your model so I can make the right adjustment to the formulas?

     

    If you want you can share it trhough private message to avoid publishing sensitive data.

     

    Regards,

    MFelix