The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi , I have a column : yearmonthweek, for example 20220414 (2022-04 and week 14).
I want to split this column into 3 and create a measure that returns the last week of each month.
For example 20220417 => "last week of April" etc...
Thank you
Solved! Go to Solution.
@Anonymous ok, so you can do:
Hi @Anonymous ,
Please refer to my pbix file to see if it helps you.
Create a measure.
Measure =
VAR _maxweek =
CALCULATE (
MAX ( 'Table'[week] ),
FILTER (
ALL ( 'Table' ),
'Table'[Year] = SELECTEDVALUE ( 'Table'[Year] )
&& 'Table'[Month] = SELECTEDVALUE ( 'Table'[Month] )
)
)
RETURN
IF ( MAX ( 'Table'[week] ) = _maxweek, 1, BLANK () )
If I have misunderstood your meaning, please provide your pbix file without privacy information and your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous Hi!
Can you paste some sample data and the expected result in explicit way?
Thx,
BF.
@BeaBF I have 3 columns: Year, Month, Week
I want to return the last week of each months.
For example : Year = 2022 , Month = 04 and Week of april = 13,14,15,16,17
I want to return 04-17
@Anonymous You have data in this way?
BF
@Anonymous ok, so you can do:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
32 | |
20 | |
17 | |
15 |
User | Count |
---|---|
56 | |
31 | |
30 | |
24 | |
21 |