Can someone help me optimize this first part of my Meausre? It has to be dynamic which is why I have to do it in a measure. The first thing I have to do is take my "Date_Date" column and for each date join with 60 days of invoicing. That is what the code below is doing but it is super slow. Any suggestions on how to speed it up? So a small example of my "virtual" table in dax would be this. Any help would be greatly apprciated.
| 1/1/2021 | | 1/1/2021 |
| 1/1/2021 | | 1/2/2021 |
| 1/1/2021 | | 1/3/2021 |
| 1/1/2021 | | 1/4/2021 |
| 1/2/2021 | | 1/2/2021 |
| 1/2/2021 | | 1/3/2021 |
| 1/2/2021 | | 1/4/2021 |
| 1/2/2021 | | 1/5/2021 |
GENERATE (
SELECTCOLUMNS (
CALCULATETABLE (
VALUES ( 'Date'[Date_Date] ),
FILTER (
ALL ( 'Date'[Date_Invoicing_Day_FLG] ),
'Date'[Date_Invoicing_Day_FLG] = 1
),
CROSSFILTER ( 'Date'[Date_Key], 'Sales Order Table'[Created Date Key], BOTH )
),
"Help", 'Date'[Date_Date]
),
CALCULATETABLE (
VALUES ( 'Date'[Date_Date] ),
FILTER (
ALL ( 'Date'[Date_Date], 'Date'[Date_Invoicing_Day_FLG] ),
'Date'[Date_Date]
<= EARLIER ( [Help] ) + 60
&& 'Date'[Date_Date] >= EARLIER ( [Help] )
&& 'Date'[Date_Invoicing_Day_FLG] = 1
)
)
)
