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
v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi, dsi 

It sounds like you need to create a calendar date table:
Ex:

Calendar = CALENDAR(DATE(2019,01,01),DATE(2021,01,01))

You can define the time range of the calendar table yourself, and then establish a one-to-many relationship between the date field in the fact table and the date field of the date table.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dsi's avatar
dsi
Frequent Visitor
6 years ago

No, that doesn't solve my problem. If I select 15.07.20 in the calendar, I only want to see records that are valid from before and valid to after.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi . dsi 

    Can you explain it more details？

    Sample data and expected output would help tremendously.
    Could you please share your PBIX/some sample data and expected result to me if you don't have any Confidential Information?

     

    Best Regards,
    Community Support Team _ Eason