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,
I am trying to do a basic lookup in DAX from the Parent SEQ Column to the ASM SEQ and return the ASM SEQ RANK (See picture below). I know that lookups can be handled in other programs easily like PQ but for my purpose it has to be in DAX as I am trying to create a ragged hierarchy which I can refresh in Excel format (I need hide members feature for pivot table). I imagine it is some variation of the lookupvalue function but I cannot get it to work.
Thanks
Solved! Go to Solution.
Hi,
Try this:
Hi,
Try this:
Thanks. I should have been able to figure that out. I am new to DAX and Its hard to learn it when you have been using Power Query forever.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |