Forum Discussion

Syk's avatar
Syk
Resident Rockstar
4 years ago

Using Dates for specific customers

Hello! I currently have this measure..

measure = CALCULATE([Digital Sales %],  DATESBETWEEN('Accounting Date'[Dates],MIN('Accounting Date'[Dates]),MAX(Issues[Go Live Date])))


I have chart to look at this measure and noticed that even though each customer has a particular go live date, it is always getting the latest date. (for every customer it uses customer A's date since its the latest)

 

How can I force my measure to look at the go live date that corresponds to the customer? Relationship between go live and customer below joined on a customer key.


 

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Syk 

    I suppose you are slicing by "Customers" from 'Ship to Cutomer' table. If the Customer name is not available in the issues table you can add it to table visual as a measure

    Go-Live Date =
CALCULATE (
    SELECTEDVALUE ( Issues[Go Live Date] ),
    CROSSFILTER ( 'Ship to Customer'[Customer Key], Issues[Customer Key], BOTH )
)

     

    • Syk's avatar
      Syk
      Resident Rockstar
      4 years ago

      While this works for a table, it throws memory errors when I try to use it in my charts.