Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
67 | |
61 | |
47 | |
35 | |
32 |
User | Count |
---|---|
87 | |
72 | |
56 | |
49 | |
45 |