Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Little stuck with this one.
I need to return the closest date value from [Last Pay Period Paycheck Column] that is <= the value within each row from column [End of Next Month]
Example: [End of Next Month] = 2/29/2020
The closest date value in [Last Pay Period Paycheck Date] that is <= 2/29/2020 woud be 2/28/2020:
Expected Result would be: [Test] = 2/28/2020
See Image below for reference and current outputs:
Solved! Go to Solution.
Is this what you need? It is a calculated column. You didnt' specify but you are showing a table.
Test =
VAR NextMonthDate = 'Table'[End of Next Month]
RETURN
MAXX(
FILTER(
'Table',
'Table'[Last Payperiod Check Date] <= NextMonthDate
),'Table'[Last Payperiod Check Date]
)
If not, can you post some actual data with expected results using the directions below?
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIs this what you need? It is a calculated column. You didnt' specify but you are showing a table.
Test =
VAR NextMonthDate = 'Table'[End of Next Month]
RETURN
MAXX(
FILTER(
'Table',
'Table'[Last Payperiod Check Date] <= NextMonthDate
),'Table'[Last Payperiod Check Date]
)
If not, can you post some actual data with expected results using the directions below?
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThat is exactly what I needed, thank you sir!
Excellent @mpicca13
Glad to help out!
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |