Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.