Forum Discussion
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 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?
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
2 Replies
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/1447523HI 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
