Forum Discussion

jorgeaon's avatar
jorgeaon
Regular Visitor
4 years ago
Solved

Difference date between rows and tables

Hello, I have a question and I've tried in several ways and I'm not getting it I have these 2 tables movlei and arqatend:   I need to create the difference of days between dates in the movlei...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI jorgeaon,

    You can use the Numatend and current date to compare with the other table same category data values to get the diff.

    diff =
VAR currDate =
    MAX ( movlei[datamov] )
VAR currCategory =
    SELECTEDVALUE ( movlei[Numatend] )
VAR currSai =
    CALCULATE (
        MAX ( Arqatend[datasai] ),
        FILTER ( ALLSELECTED ( Arqatend ), Arqatend[Numatend] = currCategory )
    )
RETURN
    DATEDIFF ( currDate, currSai, DAY )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI jorgeaon,

You can use the Numatend and current date to compare with the other table same category data values to get the diff.

diff =
VAR currDate =
    MAX ( movlei[datamov] )
VAR currCategory =
    SELECTEDVALUE ( movlei[Numatend] )
VAR currSai =
    CALCULATE (
        MAX ( Arqatend[datasai] ),
        FILTER ( ALLSELECTED ( Arqatend ), Arqatend[Numatend] = currCategory )
    )
RETURN
    DATEDIFF ( currDate, currSai, DAY )

Regards,

Xiaoxin Sheng