Forum Discussion
Date Measure
Another option could be:
DATESBETWEEN=
var _lastdate = -> your code
var _firstdate = -> your code
RETURN
DATESBETWEEN(Dates[Date],var _firstdate,var _lastdate)
DATESBETWEEN function (DAX) - DAX | Microsoft Learn
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
When I try the DATESYTD function and put it in a table, it gives me the error that says "Calculation error in measure: A table of multiple values was supplied where a single value was expected."
When I try the DATESBETWEEN function, it only returns the first value in the date table, that being, 1/1/2022, no matter what month I choose as my 'Selected Month' that the end date is supposed to be based on.
Hi NJ81858 ,
Yes, because you have to use it in combination with a calculation function. Because also with your current measure you want to calculate something else in the end, right?In the end it would look like this (example)
DATESBETWEEN and Calculation = DATESBETWEEN= var _lastdate = -> your code var _firstdate = -> your code RETURN CALCULATE( SUM(Table[Column]), DATESBETWEEN(Dates[Date],var _firstdate,var _lastdate) )If this dopes not help you then it would be helpful to get the full picture of want you intend to achive. You want a list of YTD dates but this is not the end right?
I assume you want to do a YTD calculation with a specific value. SO having a picture of the data model or some more contect would be good. 🙂
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Mikelytics This is my current data model:
I just want to apologize in advance for not being able to share my pbix file and masking all of the table names/fields, as there is highly sensitive data in the file. The highlighted table is obviously my date table, and all tables circled in blue report metrics that will use the custom date filter that this post is about. These metrics are more just reporting all values for the time period, instead of performing a calculation of sorts. The red circled tables need to be based on the same date table, but they only show a snapshot of the data from whatever the month selected is, hence why I want to have the user select only a month. In the end I hope that I can have the user select the month they want to see and the red circled tables will show only that month's data, and the blue circled tables will show all data from the beginning of the year to the end of the month selected.
piuh , okay. But no worries I fully understand that you can not share the data, but at least a get a big picture. 🙂
I mean I know you want to show data but still you do a calculation right. For the red table you takr for example the sum or max of a column for a specific month. and for the blue tables you take the sum over several months. Something like this would be possible with the appraoch I described.
Can you build an easy example with dummy data? I mean it can be a few rows manually typed in Excel.
- 1 date table (this I know how it looks like) 😉
- 1 red table example
- 1 blue table example
- and an example what you want to Calculate/vizualize
It only has to be a few rows per table
Best regards
Michael