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.
I have a column of dates and a colum of "Avg days to collect". I want to calculate the expected date of collection by adding the number of days the dates in the first column. Suggestions?
If your existing date field is recognised as date type you can either add it as a column or create a measure.
Column:
Column = 'Table'[date] + 'Table'[add date]
Measure:
Measure = sumx('Table';'Table'[date] + 'Table'[add date])
Kind regards
Joren Venema
Data & Analytics Consulant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Thanks, but what if they each column is from a different table? I've tried adding them together, but it keeps defaulting the date to a Count of Date.
Assuming you have a relation between the 2 tables you can use the related() function.
Try the following:
Measure = sumx('Table';'Table'[Date] +RELATED('Table (2)'[add date]))
Kind regards
Joren Venema
Data & Analytics Consulant
If this reply solved your question be sure to mark this post as the solution to help others find the answer more easily.
Thank you. Still having an issue. I have a relationship between the tables, but for some reason I am getting an error that they are not related. See screenshots below. One of each table and one of the error. They are both related by the client ID.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |