Forum Discussion
[DAX] Getting particular date from one query to another
Hello everyone, I'm facing an issue while trying to "export" one date from one query into another using DAX. My structure of data looks like that: Both tables are connected with "one-to...
hi, Anonymous
You could use this simple formula
Column = CALCULATE(MAX(Tasks[AStageCreatedDate]),ISBLANK(Tasks[AStageCreatedDate])=FALSE())
Result:
Best Regards,
Lin
Requests:
IdTitleCreated DateModified DateStage
| 1 | Test1 | 01/01/2018 | 16/01/2018 | B |
| 2 | Test2 | 01/02/2019 | 16/02/2019 | C |
| 3 | Test3 | 01/03/2018 | 16/03/2018 | D |
| 4 | Test4 | 01/05/2018 | 16/05/2018 | D |
| 5 | Test5 | 01/04/2019 | 16/04/2019 | C |
| 6 | Test6 | 01/03/2019 | 16/03/2019 | B |
Tasks:
Request IDTitleCreated DateModified DateTask StageId
| 1 | Test1 | 13/03/2018 | 28/03/2018 | A | 1 |
| 1 | Test1 | 03/04/2018 | 18/04/2018 | B | 2 |
| 2 | Test2 | 13/04/2019 | 28/04/2019 | A | 3 |
| 2 | Test2 | 04/05/2019 | 19/05/2019 | B | 4 |
| 2 | Test2 | 13/04/2019 | 28/04/2019 | C | 5 |
| 3 | Test3 | 01/06/2018 | 16/06/2018 | A | 6 |
| 3 | Test3 | 11/05/2018 | 26/05/2018 | B | 7 |
| 3 | Test3 | 01/06/2018 | 16/06/2018 | C | 8 |
| 3 | Test3 | 11/05/2018 | 26/05/2018 | D | 9 |
| 4 | Test4 | 01/08/2018 | 16/08/2018 | A | 10 |
| 4 | Test4 | 11/07/2018 | 26/07/2018 | B | 11 |
| 4 | Test4 | 01/08/2018 | 16/08/2018 | C | 12 |
| 4 | Test4 | 11/07/2018 | 26/07/2018 | D | 13 |
| 5 | Test5 | 02/07/2019 | 17/07/2019 | A | 14 |
| 5 | Test5 | 11/06/2019 | 26/06/2019 | B | 15 |
| 5 | Test5 | 02/07/2019 | 17/07/2019 | C | 16 |
| 6 | Test6 | 11/05/2019 | 26/05/2019 | A | 17 |
| 6 | Test6 | 01/06/2019 | 16/06/2019 | B | 18 |
That seems like a good news! Awaiting your solution then
v-lili6-msft
Community Support
Community Supporthi, Anonymous
You could use this simple formula
Column = CALCULATE(MAX(Tasks[AStageCreatedDate]),ISBLANK(Tasks[AStageCreatedDate])=FALSE())
Result:
Best Regards,
Lin
Hello v-lili6-msft,
that seems to work for me, thank you very much!
Best regards,
Bartek.