Forum Discussion
How to generate explode the datediff between 2 dates to multiple rows
Thank much AlexisOlson ,
1) regarding the Dax approach, I have the "DayssinceStartDate" as part of the dataset and Dax is not recognizing this field, in the, GENERATESERIES ( 1, [DaysSinceStartDate] ) ) ? unless its part of aggregate function
2) regarding the approach1 (custom), is this going to be new dataset and how to refer to the source dataset assuming its 'table1' and has the fields, startdate,enddate and dayssinceStartDate ?
3)Assumimg I am going with the dax way, need to have the startDate columm from table1 along with DaysSinceStartdate to be able to define relationship to other table which has just the startDate (single value)
End goal is I need to able to plot the DaysSinceStartDate on the x-axis of chart with the counts from the table1 which has the startdate and enddate fields
It gives me an angry red underline too but it does work. I think this is probably a bug in the IntelliSense.
I'm sorry but I don't quite follow what you're getting at in 2 and 3.