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.
I have some complex requirements for a DAX formula that I can't quite figure out.
Cases are attributed to Counties. That Case -> County attribution changes over time. The Case table can have new rows every several months, but it is not regular and cannot be depended on.
I need a matrix with the average age of the case on the values, county on the rows, and month on the columns. The age of the case needs to 'carry forward' and appear in each month until the next entry in the Case table.
This must be a DAX solution, it cannot be a Power Query solution. Relationships between tables can be changed or removed if necessary for the solution.
Here's my sample data:
Here's the required result:
Here is a link to download my pbix: https://www.dropbox.com/scl/fi/vn7cgah4ru4zilnvm3580/20250422-Power-BI-DAX-Question.pbix?rlkey=tinuh...
Solved! Go to Solution.
You need to disconnect all tables and then work it from the perspective of the case, looking up.
That is the most amazing thing I've ever seen. I tip my hat to you.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |