Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi There,
I have a task which I need to accomplish for my work purposes. I have two table Fact and Employee info Table. The task is to get the Dept and Cost Cost on Based on Date of Examine. In words, Fact table would look into Dim Table to see an employee in Dim Table with matching ID, Filter whole table just for that employee and then based on Date of examining would return value for Dept and Cost.
Thanks in Advance!
For example, in below Fact table, Values should be as per below:
@Anonymous ,
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/Lookup-Price-Range-for-Style/m-p/322514#M143719
Hi there,
I'm not quite getting there. Could you help? My situation is a little different from the one you pointed to.
Let me know how I could share some data with you.
Thanks,
Thanks for your reply! let me try that out and if this works, I'll accept this as a solution, if not can I please ask you for assistance?
Thanks,