Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Desktop Calculation help

I have below excel calculation and I am not sure how to replicate it on Power BI. 1. Basically, I show column A, B, C and D, and create a column (filter) which only shows rows which have Inconsisten...
Need Help
Show and Tell
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Anonymous ,

    From your description, you could refer to below formulas:

    Category-1 = IF([A]=[B]&&[B]=[C]&&[C]=[D],"OK","Check")
    Category-2 = IF([A]+[B]+[C]+[D]>[E]+[F]+[G],"Check","OK")

    Result:

    You could also download the pbix file to have a view.

     

    Regards,

    Daniel He

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

From your description, you could refer to below formulas:

Category-1 = IF([A]=[B]&&[B]=[C]&&[C]=[D],"OK","Check")
Category-2 = IF([A]+[B]+[C]+[D]>[E]+[F]+[G],"Check","OK")

Result:

You could also download the pbix file to have a view.

 

Regards,

Daniel He