Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
How can I make this table dynamic in power BI. In next week, when the source data is updated with a new week (week 23) then this table should automatically gets refreshed like (week 18 should be removed and week 23 should be added in the feild)
Solved! Go to Solution.
Hello,
Assumption: The weeks will be displayed only for a selected year. (i.e. the weeks are all from the same year and not from 2 different years).
You can follow the below steps and achieve the requirement:
1. Create a duplicate column of the Week Name. [ex: "Week 18 (2-8 May)" ]
2. Split the text with space delimiter and retain the column which gives the week number only. (i.e. 18, 19, 20 etc.)
3. Create a measure finding maximum of the week number.
@Rahul_SC
Would you please consider marking my reply as acceptable soltion? Thank you
Hello,
Assumption: The weeks will be displayed only for a selected year. (i.e. the weeks are all from the same year and not from 2 different years).
You can follow the below steps and achieve the requirement:
1. Create a duplicate column of the Week Name. [ex: "Week 18 (2-8 May)" ]
2. Split the text with space delimiter and retain the column which gives the week number only. (i.e. 18, 19, 20 etc.)
3. Create a measure finding maximum of the week number.
Hi @Rahul_SC
please follow the instructions in this video. You just need to change the 6 months period with 6 weeks period
thanks for the link, it worked.
@Rahul_SC
Would you please consider marking my reply as acceptable soltion? Thank you
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |