Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Community,
I am revisiting a problem DAX that is missing something slight!
I have applied the below formula but found it didnt like the Emb Estimated Delivery Date:
It doesnt give me the option to select from a different table?
So I have used SELECTEDVALUE to access the column from another table and have the below:
However the DAX does not return a value:
I'm pretty new to Power BI so my understanding is still developing 🙂
Solved! Go to Solution.
Hi Andy,
Its me, you but in the future, I figured out the solution:
Hi Andy,
Its me, you but in the future, I figured out the solution:
Hahaha. Thank you for sharing future you.
Try to use ISBLANK rather than [Expected Delivery Date] = BLANK(), and use Related if there is a relation between those tables or use Lookupvalue.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos✌️!!
Thank you for your reply, ISBLANK doesnt seem to work either, in order to give you more info I have included step by step my current chain of thought.........there isnt a direct relationship between the 2 tables, relationships as below:
i) Orders > Prod/Colour = Next Supply Date > Prod/Colour
ii) Orders > Prod Base/Colour = Next Supply Base Product > Prod/Colour
I would like to create a new column within the 'Next Supply Date' named 'Expected/Estimated Delivery Date' I would like this newly created column to look at the 'Next Supply Date[Expected Delivery Date]' and if this date is blank/null/no value, to return back the date 'Next Supply Base Product'[Emb Estimated Delivery Date] else if 'Next Supply Date[Expected Delivery Date]' is not blank/null/no value to retain that value.
A Crystal report formula equivilant would be something like:
IF (ISNULL('Next Supply Date[Expected Delivery Date]')) THEN 'Next Supply Base Product'[Emb Estimated Delivery Date] ELSE 'Next Supply Date[Expected Delivery Date]'
Can anyone suggest the best course of action in this case?
Currently I'm using this
Which is returning:
What I should be seeing in 'Expected/Estimated Delivery Date' are dates pulled in from 'Emb Estimated Delivery Date' where 'Expected Delivery Date' has no value.
Many thanks in advance,
AJ
If there is a proper relationship then use RELATED()
RELATED(<column>)
Expected/Estimated Delivery Date =
VAR prod_colour = [Prod/Colour]
RETURN
IF (
[Expected Delivery Date] - BLANK (),
RELATED ( [Emb Estimated Delivery Date] ),
[Expected Delivery Date]
)
Thank you for your reply, there isnt a direct relationship between the 2 tables, relationships as below:
i) Orders > Prod/Colour = Next Supply Date > Prod/Colour
ii) Orders > Prod Base/Colour = Next Supply Base Product > Prod/Colour
I would like to create a new column within the 'Next Supply Date' named 'Expected/Estimated Delivery Date' I would like this newly created column to look at the 'Next Supply Date[Expected Delivery Date]' and if this date is blank/null/no value, to return back the date 'Next Supply Base Product'[Emb Estimated Delivery Date] else if 'Next Supply Date[Expected Delivery Date]' is not blank/null/no value to retain that value.
A Crystal report formula equivilant would be something like:
IF (ISNULL('Next Supply Date[Expected Delivery Date]')) THEN 'Next Supply Base Product'[Emb Estimated Delivery Date] ELSE 'Next Supply Date[Expected Delivery Date]'
Can anyone suggest the best course of action in this case?
Currently I'm using this
Which is returning:
What I should be seeing in 'Expected/Estimated Delivery Date' are dates pulled in from 'Emb Estimated Delivery Date' where 'Expected Delivery Date' has no value.
Many thanks in advance,
AJ
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |