Forum Discussion
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...
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
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