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.
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())
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |