Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |