View original (French)

Conditional calculated field

rimoa Posted messages 153 Registration date   Status Member Last intervention   -  
DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   -
Hello, thank you in advance for your help. I want to insert a calculated field with an IF condition that will allow me to output the final bonus but only if the status is required and without displaying the status in the pivot table.

https://www.cjoint.com/c/LAcdGPLEtam

3 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Re
    Yes, it's a measure.
    There are two ways to create formulas: with calculated fields or with DAX language. What you want to do is not possible with calculated fields. The formulas operate on fields. You need formulas that work on the table.
    You right-click in the fields table on fxrequis and then on modify.

    The other way is with data ==> modify data.

    You didn't provide your version of Excel, because with Excel 365, it's simpler!

    Best regards.
    1
  3. rimoa Posted messages 153 Registration date   Status Member Last intervention   1
     
    Hello, could you please tell me the formula you used for the required fx field that I see in the list of fields, and how you created it? Is it a calculated item?
    0