Forum Discussion
Value between Two Dates
Bibiano_Geraldo Many thanks. That looks great - however, instead of month end, in the DAX you've offered, is there a way of just using the month of 'Sales Letter B Date' - in the sample data I supplied, it's always October 2023. But this will change each time I use a new data source - I just need to the DAX to pick up the month of the Sales Letter B Date and apply to the DAX you've supplied above. Huge thanks!
Hi Creative_tree88 ,
Have one of this reply solved your problem? please consider to accept as solution.
About separeted rows, i gave your answer in another post, but just for context, i'll paste here the reply:
You can achieve the desired result by creating a new calculated table using the following DAX:
NewTable =
VAR Separator = "|"
RETURN
SELECTCOLUMNS(
GENERATE(
'YourOriginalTable',
VAR ExaminationsList = SUBSTITUTE('YourOriginalTable'[Examinations], ",", Separator)
RETURN
SELECTCOLUMNS(
GENERATESERIES(1, LEN(ExaminationsList) - LEN(SUBSTITUTE(ExaminationsList, Separator, "")) + 1),
"Report ID2", [Report ID],
"SplitValue", PATHITEM(ExaminationsList, [Value], TEXT)
)
),
"Report ID2", [Report ID2],
"SplitValue", [SplitValue]
)
Your output will look like this:
Make sure to replace table and columns names with your owns.