Obtain Values from dim table in Many to Many relationship based on date value in Fact table

[Anonymous]

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:

[v-chuncz-msft]

@Anonymous ,

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Lookup-Price-Range-for-Style/m-p/322514#M143719

[Anonymous]

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,

[Anonymous]

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,