Multiply value if other value =X

[BobKoenen]

Hi all,

I am relatively new and hope you guys can help me out with how to do this in DAX I want a column Amount filled as followed.

If HourCode = 389998 then Hours * 60 in the column Amount.  How can i do this?

[AlB · Accepted solution]

Hi @BobKoenen

The code for your amount Column:

        IF(Table1[HourCode]=389998; Table1[Hours]*60)

if Table1[HourCode] is a number, or 

       IF(Table1[HourCode]="389998"; Table1[Hours]*60)

if Table1[HourCode] is text

Substitute Table1 with the name of your table