Forum Discussion
Solved
Dax Help: Create table with variable # of lines according to date difference
Hi! I'm having big trouble to create a new table, does anybody know the solution? it would help a Lot!! I Have a table with orders like this: Order Original Date Actual Date Difference...
You may refer to the DAX below.
Table = VAR c = CALENDARAUTO () RETURN GENERATE ( Table1, FILTER ( c, [Date] >= Table1[Original Date] && [Date] <= Table1[Actual Date] ) )
You may refer to the DAX below.
Table =
VAR c =
CALENDARAUTO ()
RETURN
GENERATE (
Table1,
FILTER ( c, [Date] >= Table1[Original Date] && [Date] <= Table1[Actual Date] )
)
Worked perfectly, thanks!