Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have two tables:
T1 holds: interviewID, status, statusvalue & statusdate
T2 holds: interviewID, lots of other columns and a new column created by DAX which I want to store a date when a certain status & statusvalue is found in T1.
T2 new column measure =
Solved! Go to Solution.
Solution remove the 'SELECTEDVALUE' from the DAX:
T2 new column measure = LOOKUPVALUE('T1'[StatusDate], 'T1'[interviewId],' T2'[interviewId], T1[status],"Quoted", T1[statusvalue],"Complete")
No, as the data is commercially sensitive.
The two IDs are wholenumbers, the status and statusvalue are text and the date to return and the new column are both datetime
Hi @RichHead1821 ,
Try creating some dummy values. i can try but you know how the data looks like 🙂
Regards,
Harsh Nathani
How do I share a PBIX file here?
Hi @harshnathani - I have an example PBIX file which demonstrates this (with dummy data) - but have no idea how to share that data
This is T1
This is T2
Relationships
@RichHead1821 , I do see any date in T1. But any date in T1 in slicer can filter T2
I am trying to create the date in T1, using the DAX in the first screenshot...
Solution remove the 'SELECTEDVALUE' from the DAX:
T2 new column measure = LOOKUPVALUE('T1'[StatusDate], 'T1'[interviewId],' T2'[interviewId], T1[status],"Quoted", T1[statusvalue],"Complete")