Forum Discussion
Joining 2 tables depending on its valid date (between)
Hi,
I'm fairly new to PowerBI and I got stucked while trying to rebuild the following join in Power BI.
Is there a way to modell this join in Power BI?
FACT_HOLDINGS.ISSUER_ID = DIM_ISSUERS.ISSUER_ID
AND FACT_HOLDINGS.VALID_DATE BETWEEN DIM_ISSUERS.VALID_FROM AND DIM_ISSUERS.VALI_TO
Thanks
Christian
3 Replies
- amitchandak
Super User
christiang , We have create such join in measures
refer example
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785 - v-luwang-msft
Community Support
Hi christiang ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien Hi,
Unfortunately the proposed solutions don't work for me. I'll share my solution once I'll have one. Thanks.
