Forum Discussion

bIearner83's avatar
bIearner83
Frequent Visitor
2 years ago
Solved

If condition not working for Dates

Hi Everyone, I have two tables 'Sales' & 'Customers'. There is a Date column in Sales table with the name "SalesDate" that I want to add hours based on the Customers locations.   The Customers tabl...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    bIearner83 , a new column in the sale table

     

    = if(related(customer[Name]) = "bunnings" , [sales date] + time(8,0,0) , [Sales Date])

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

is your formula a measure or calculated column?

I think you have a problem here:

DynamicDate =
VAR SalesDate = Sales[SalesDate]
VAR Customers = MAX(Customers[CusName])

  • bIearner83's avatar
    bIearner83
    Frequent Visitor
    2 years ago

    Ahmedx  thanks for your reply. Yes, it's a calculated column. for some reason, the Customers = MAX(Customers[CusName]) is not working. I have tested the value of Customers like below and it's only returns a fixed value of the first customer. When apply the filter and using table, it's shows the exact value which is filtered out but here it's not working.

    DynamicDate =
    VAR Customers = MAX(Customers[CusName])
    RETURN
        Customers

     

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result.