Forum Discussion
Calculated Column returning Blank Rows
Hello,
I want to calculate a new column "target sale". I have a 1:* relationship between the product table(where the product price is) and the
target table (with the target quantities). When I wrote my DAX it's returning blank rows. What might be the cause?
Thank you
It's working now, I went to rename the column in PQ, it's a different value in the ProductID when I change the column.
3 Replies
Your DAX code looks okay. One possibility is there are some extra spaces after the productID in one of the table that causes a mismatch. It happens some times. Just add a calculated column on both tables using
ProductID_Length = LEN(ProductID)on both tables and see if if the number of characters on productID in both the tables are same or different. If they are different, you might have to correct it and make the ProductIDs match in both the tables. This is just one possibility
Thank you
It's working now, I went to rename the column in PQ, it's a different value in the ProductID when I change the column.
