The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
am not able to sort on week number. I am using calender table where I have fields
1. Weekname - String format(Week-01, Week02 etc...)
2. Weeknum = Number (1, 2 etc..)
here am trying to sort based on weeknum but am getting error as shown in screenshot below.
@Chandrashekar , Of they follow same logic
Example
Week Name = "Week " & weeknum([Date], 2)
Week Sort= weeknum([Date], 2)
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
Hello,
Can you please me on it.
Regards,
Chandrashekar B
Hello Amit,
I tried your solution but it is not working for me. I have attached sample data can you please let me know how to fix it.
Regards,
Chandrashekar B
Hello Amit,
I am sharing working file which I worked and not working for me.
Sample: Sample Data
Regards,
Chandrashekar B
Hello,
Can you help me on it.
Regards,
Chandrashekar B
Hello,
Any solution for it.
Regards,
Chandrashekar B
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |