Forum Discussion

manideep547's avatar
manideep547
Helper III
6 years ago

Based on range

Hi, I have 3 tables 1]date(calendar auto) 2]customer_Activity(State) 3]transaction (Id  date ) ->The date table contains dates. ->customer_Activity contains (one columns with two values "Active...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi manideep547 ,

Maybe you need to add a ALLSELECTED() function:

customer Relation = 
VAR x =
IF(
  DATEDIFF(
    SELECTEDVALUE(transaction [date]),
    MIN(Date[Date]),MONTH
  )>6,
  "Inactive","Active"
)
RETURN
CALCULATE(
  x,
  ALLSELECTED(Date[Date])
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.