Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have two date column,
one column has month-year and another column is weekend-dates, like below image
i want to have only one matching month and year of the month column, like below
the issue is starting of month and end of month sometimes present in previous month as highlighted in first image,
can someone help me get the result of 2nd image, any date is fine as long it is only one date matching the month column, so i could use it in my slicer.
Solved! Go to Solution.
Here is one way.
1) a measure for the date :
2Wk Date =
VAR _Month =
MAX ( 'Table'[Month] )
VAR _RNK =
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Month] = _Month ),
[Date Measure],
,
ASC
)
RETURN
CALCULATE (
[Date Measure],
FILTER ( ALL ( 'Table'[Month] ), 'Table'[Month] = _Month && _RNK = 2 )
)
3) and a final measure to display this date by month
2wk date by month =
MAXX (
SUMMARIZE ( 'Table', 'Table'[Month], 'Table'[wk_end_dt], "_okDate", [2Wk Date] ),
[_okDate]
)
Proud to be a Super User!
Paul on Linkedin.
Here is one way.
1) a measure for the date :
2Wk Date =
VAR _Month =
MAX ( 'Table'[Month] )
VAR _RNK =
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[Month] = _Month ),
[Date Measure],
,
ASC
)
RETURN
CALCULATE (
[Date Measure],
FILTER ( ALL ( 'Table'[Month] ), 'Table'[Month] = _Month && _RNK = 2 )
)
3) and a final measure to display this date by month
2wk date by month =
MAXX (
SUMMARIZE ( 'Table', 'Table'[Month], 'Table'[wk_end_dt], "_okDate", [2Wk Date] ),
[_okDate]
)
Proud to be a Super User!
Paul on Linkedin.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
87 | |
65 | |
50 | |
45 |
User | Count |
---|---|
217 | |
88 | |
81 | |
65 | |
56 |