Forum Discussion
Help with dax (most recent date)
Hello! I need to create a calculated column that does the following: Check if the reference (Second column) is repeated in the same month, and if it is repeated, bring the most recent one. ...
Hi,
Will you be OK with a Power Query solution? If yes, then share the data in a format that can be pasted in an MS Excel file.
| Date | Ref | Expected Result |
| 16/01/2025 13:01:22 | 001702731321 | |
| 16/01/2025 18:15:05 | 001702731321 | 001702731321 |
| 23/01/2025 18:04:53 | 001744616718 | 001744616718 |
| 23/01/2025 17:11:05 | 001744616718 |
in this case the reference is repeated, so the expected value is to bring the reference only in the line with the most recent date
Hi,
PBI file attached.