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.
Hi there ;
ı need your support to create a column as below ;
i have two tables , Table A and Table B , Table A has only order numbers and Table B has Order numbers and delivery dates.
Table A and Table B has relationship via Order Numbers.
i want to create a new colum in Table A named " Last Date " , and rule will be like that :
thanks in advance for your kind supports
Solved! Go to Solution.
You don't need to add an extra column to your model (it could be done with a measure). But if you want to add the column, you can use this expression from your Table A.
LatestDelDate = CALCULATE(MAX(TableB[Delivery Dates]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You don't need to add an extra column to your model (it could be done with a measure). But if you want to add the column, you can use this expression from your Table A.
LatestDelDate = CALCULATE(MAX(TableB[Delivery Dates]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |