Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I would like to create flag for current max week and last week data only.
For example, I have this table -
I would like to create dynamic flag like this
However, next week it should be look like this;
Thus, every week flag will change based on max current week and previous week of max week.
Any help will be appreciated.
I have tried following solution;
1) Rankx
2) Create variable with max week then compare with dim date table.
3)Swithc function with max week = week from dim_date && max week-7 = week from Dim_Date-7.
Thank you in advance!
Solved! Go to Solution.
hI @damit23183 ,
Please try this:
Flag =
VAR __MAX_WEEK =
MAX ( 'Table'[Week] )
RETURN
__MAX_WEEK - 'Table'[Week] <= 7
hI @damit23183 ,
Please try this:
Flag =
VAR __MAX_WEEK =
MAX ( 'Table'[Week] )
RETURN
__MAX_WEEK - 'Table'[Week] <= 7
Hi,
Thank you for your response and solution that worked perfectly fine.
Thanks
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |