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,
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")
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |