Forum Discussion

dsi's avatar
dsi
Frequent Visitor
6 years ago

Historization valid from valid to

Good morning, Does anyone have an idea how I can display only those records that are within my validity period? I would like to be able to look back in my historical data and see the records that a...
Need Help
az38's avatar
az38
Community Champion
6 years ago

dsi 

how to you want to display it and why do you think calculated table is so slow?

In the most common case you can create a Calendar Table with additional column like

Calendar Table = 
ADDCOLUMNS(
 CALENDARAUTO(),
 "Total Value",
 CALCULATE(SUM(Table[Value]), FILTER(Table, Table[StartDate] <= EARLIER([Date]) && (Table[EndDate] >= EARLIER([Date]) || ISBLANK(Table[EndDate]) ) )
)