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

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