Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I am a beginner in Power BI and coming from Excel, as the most of us.
My challenge is that I have two tables. In table 1 there are entries with speed limits. The position of the speed limits is based on a hierarchy in the columns road number, road section (every road has sections from 1 to n) and mileage.
In table two is the data about the road network. Every entry is a road subsection (from junction to junction) which is based on a hierarchy in the columns, road number, road section and mileage from, mileage to.
My goal is to add a column in table 1 which shows in which subsection from table two the speed limit fits. The formula has to proof, if the road number and the road section are the same and if the mileage from the speed limit is between mileage from and mileage to.
An additional information is, that mileage from can be greater or smaller as mileage to.
I hope someone can help me.
Thank you!
Best regards, André
Solved! Go to Solution.
Hi @anhe91
Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |