Forum Discussion
Multiple IF Conditions using DAX
Hi there, very new to the BI world and queries in general. Im sure this is a simple ask. My data set includes list of employees across multiple product lines. The User name is repeated throug...
Anonymous , Try like this
Worked Revenue=
Switch(true(),
[Product] = "Jane Inc", 10,
[Product] = "Doe Coe",20,
10
)*[Line Hours]
Better Create a table "Rate" with Product, Rate . Join on product and try
Worked Revenue=
related(Rate[Rate])*[Line Hours]