Forum Discussion

yayamiko's avatar
yayamiko
New Member
3 years ago
Solved

Issue dealing with multiple date

Hi,   Let's say i have a table that describe a list of items and their day of order and their shipping day. So i have two differents date. The thing is i need a report that say the number o...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You don't need a relationship for this scenario, you can use something like

    Num items =
VAR ReferenceDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Order date] < ReferenceDate
            && 'Table'[Shipping date] > ReferenceDate
    )
RETURN
    Result
johnt75's avatar
johnt75
Super User
3 years ago

You don't need a relationship for this scenario, you can use something like

Num items =
VAR ReferenceDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        'Table'[Order date] < ReferenceDate
            && 'Table'[Shipping date] > ReferenceDate
    )
RETURN
    Result
  • yayamiko's avatar
    yayamiko
    New Member
    3 years ago

    Hi johnt75 .

     

    Thank you so much. This is exactly what i wanted.

     

    i came up the same dax measure but my variable ReferenceDate was equal to 

     

    selectedvalue(date[date])

     

    and it didn't do anything.

     

    Thanks