Forum Discussion
Value between Two Dates
Hi - I have the following DAX which is in a calculated column. The issue I'm having is that it's saying there are multiple values where single is expected. Is there any way of adapting this express...
Hi Creative_tree88 ,
As i mentioned in my reply, ised the Min function just for example, as these variables reference another table, you need to aggregate them as your need, because its expected one value not multiple values, if you help me showing the expected output i can refine the logic, can you please give me more details of your expected result?
Bibiano_Geraldo As an example - I've found 4 lines of data which show what I need. The examinations column will be what this formula will eventually display. It will find the examinations between two dates and populate - if just one date, it looks specifically at that date and pulls the examination. Perhaps there is another DAX method I can use? Any help much appreciated.
| KEY | Sales Letter A Date | Sales Letter B Date | Examinations |
| 447064 | 02/10/2023 | 08/10/2023 | UDRAII |
| 471947 | 15/10/2023 | ZNCONS | |
| 539305 | 25/10/2023 | 25/10/2023 | UINJTJ |
| 651438 | 15/09/2023 | 10/10/2023 | FNRBK |