Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi there,
I'm really stuck trying to sort these subvalues, by value, week, quarter and year
Like:
Weeks | value
1 | 20
1 | 15
1 | 9
--------------
2 | 25
2 | 23
2 | 20
The main problem is that i just have access to the data through PBI dataflows not the original source so i could not use
an extra table or column.
I found that maybe add calculated fields could work or rankx, but still nothing works.
Thanks in advance.
I want this order
per week
I want to sort in descending order every value per week
Like
Week 1
15,14, 10
Week 2
25, 20, 19
Hi @Anonymous, how are you wanting to sort them? What's the end output you're after?
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
98 | |
75 | |
69 | |
49 | |
26 |