March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
125 | |
85 | |
69 | |
54 | |
45 |
User | Count |
---|---|
204 | |
106 | |
98 | |
65 | |
54 |