Forum Discussion

SwatKat's avatar
SwatKat
Frequent Visitor
2 years ago
Solved

Look up within Same Table based on Order Created Date

Hi,   I have a Orders  table as below in my Power BI file . I need to show list of customers who have Ordered Online in the past. This will be used in a table visual. I tried Look Up but that is no...
Need Help
  • Martin_D's avatar
    Martin_D
    2 years ago

    Hi SwatKat ,

    I'd recommend to solve this problem in a measure, not in M Query. This DAX measure

     

     

    Has ordered online = IF ( "Online" in VALUES ('Orders'[Source] ), "Yes", "No" )

     

     

    will give you this result:

    Kind regards,

    Martin

alexschindler's avatar
alexschindler
Helper I
2 years ago

Hi SwatKat

Can you not use some measure for this?

Something along the lines of ...

ordered_online =
VAR ordered_online_in_past = CALCULATE(DISTINCTCOUNT(order_table[OrderID]), FILTER('orders_table', orders_table[Source] = "Online"))
RETURN
IF(ordered_online_in_past > 0,
"yes",
"no"
)

Good luck

Alex

  • SwatKat's avatar
    SwatKat
    Frequent Visitor
    2 years ago

    Thanks Alex for your solution. I have tried solution provided by Martin_D  and it worked. It looks like your solution will work pretty fine too. 

     

    Thanks for the prompt responses