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 three tables:
1. - Expected Date
2. Ship Date
3. Order Table
The order table has relationships with the Expected Date Calendar table and the Ship Date Table. I've put the columns I need in a matrix.
I am wanting to compare the Due Date (in WVL) column to the Ship Date column. If the Due Date column is > than the Ship Date Column, Not ok, OK.
It SEEMS like it would be a simple IF function - but it won't reference the columns properly. I've tried using the RELATED function - says it needs to be a fully qualified column. Any ideas of how to make this work properly?
Thanks in advance!
NOTE: the relationship between the orders table and the two different dates table - is based off a date id for each table. the orders table has a shipdateid column and a expecteddateid column. Many to one, I believe.
Solved! Go to Solution.
May seem trivial but you are in fact making a calculated column and not a measure?
What DAX formula did you use for your custom column? Did you use the TableName[ColumnName] syntax?
@dkay84_PowerBI - Hey! 🙂 I did -
I did a basic IF formula to start IF('Expected Date'[Due Date (in WVL)] > 'Ship Date'[Ship Date], "Not ok", "ok")
May seem trivial but you are in fact making a calculated column and not a measure?
Perfect!! 🙂 I thought I had tried the column but apparently, I had tested the measure and not created a calculated column. That did it!
Thanks so much!
THANK YOU!!!!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |