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.
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
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |