Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm having problems getting an expression to work as I am getting the "Expressions that yield variant data-type cannot be used to define calculated columns".
This is what I entered "QC Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate],17,DAY),"")"
I bascially need to say that if an item is in a specific warehouse, then add 17 days to the "Receipt Date" else Null.
Can someone help me with thisp please?
Thank you!
Try using BLANK() instead of "".
You are trying to return a number under one condition and text under the other condition.
Now I am getting a different error.
"Function 'DATEADD' expects a contiguous selection when the date column is not unique, has gaps or it contains time portion."
Perhaps try:
QC Release Date = IF(IM_ItemWarehouse[Warehouse Code] = "QC",DATEADD(IM_ItemCost[ReceiptDate].[Date],17,DAY),BLANK())
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |