Forum Discussion

SWAL's avatar
SWAL
New Member
4 years ago
Solved

Value based on filter DAX

Dear all   Thank you for the great work in this Forum. I have learned the ins and out of BI.   I have a problem with calculation a date based on a "Product Name" in dax and don't seem to be find ...
Need Help
  • SWAL's avatar
    SWAL
    4 years ago

    Hi All

     

    I have manager to resolve the problem  as follows:

     

    Measure =
    IF(MAX('Product'[Product Name])="Orange",'Data'[ProdDate]+15,
    IF(MAX('Product'[Product Name])="Audio",'Data'[ProdDate]+10,
    IF(MAX('Product'[Product Name])="Awake!",'Data'[ProdDate]+5)))
     
    How this will be useful
     
     
SWAL's avatar
SWAL
New Member
4 years ago

Turns this but it has a glitsh in that only uses the first VALUE

 

Measure = CALCULATE(
SWITCH(FALSE(),
VALUES('Product'[Product Name]) = "Orange", sum('Product'[Date]) +15,
VALUES('Product'[Product Name]) = "Apple", sum('Product'[Date]) +10 ))