Difference date between rows and tables

[jorgeaon]

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 table of the Numatend , but the last line referring to the Numatend should make the difference between the dates of the Arqatend table, that is, the duration in days of the movlei.datamov and the arqatend.datasai .

Please can help me?

[v-shex-msft · Accepted solution]

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

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. I cannot use screenshots of your source data.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523