Forum Discussion
Add date and time columns together without creating a calculated column or using power query
In my hypothetical, I need to find the number of drafts for each of the below articles.
You will notice that some books had multiple drafts e-mailed on the same day, so it's necessary to use both the draft e-mailed time and draft e-mailed date to figure out which draft is the most recent.
I would like to do this without creating a Draft E-mailed DateTime column in power query or a DAX calculated column. Is there a way to do so?
Starter Table:
| Editor | Article ID | Article Draft ID | Draft E-Mailed Date | Draft E-Mailed Time |
| Sam | 4751 | 1346dhsf | 5/21/2022 | 1:13:00 AM |
| Jenny | 5534 | 7r346666 | 6/13/2022 | 2:51:00 PM |
| Lee | 4839 | aag3433 | 7/1/2022 | 4:00:00 AM |
| Robin | 4027 | 0ffasdd | 2/1/2022 | 10:32:00 AM |
| Lee | 4420 | ccee555 | 2/3/2022 | 5:00:00 PM |
| Sam | 4751 | f4tyyyy | 5/21/2022 | 5:16:00 AM |
| Jenny | 5534 | fase3thh | 6/13/2022 | 10:32:00 PM |
| Lee | 4839 | fasd34666 | 7/1/2022 | 6:54:00 PM |
| Sam | 6678 | jj4668trey | 8/16/2022 | 7:00:00 AM |
| Lee | 4420 | eueytuuu | 2/4/2022 | 6:00:00 AM |
| Sam | 4751 | kguiuu648 | 5/21/2022 | 8:21:00 AM |
| Lee | 4420 | xxcgh6555 | 2/4/2022 | 7:00:00 AM |
Goal table:
| Editor | Article ID | Draft Count | Draft ID | Most Recently Emailed Draft's Date | Most Recently Emailed Draft's Time |
| Sam | 4751 | 3 | kguiuu648 | 5/21/2022 | 8:21:00 AM |
| Robin | 4027 | 1 | 0ffasdd | 2/1/2022 | 10:32:00 AM |
| Jenny | 5534 | 2 | fase3thh | 6/13/2022 | 10:32:00 PM |
| Lee | 4839 | 2 | fasd34666 | 7/1/2022 | 6:54:00 PM |
| Sam | 6678 | 1 | jj4668trey | 8/16/2022 | 7:00:00 AM |
| Lee | 4420 | 3 | xxcgh6555 | 2/4/2022 | 7:00:00 AM |
2 Replies
vicky_Super User
You can use MAX(Most Recently Emailed Draft's Date, Most Recently Emailed Draft's Time), or MAXX() if you've got multiple rows you need to look at.