The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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")
User | Count |
---|---|
11 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
10 | |
8 |