Filtering which includes Blanks on Bitemporal Tables

Hi postvijay 
Sorry fo the late response.
PLease do check the below detailed steps that might resolve your issue.

To address performance and data consistency issues in your Power BI model with bitemporal and snowflake schema design, consider flattening related tables (like A1–A7, B1–B3, etc.) into their respective central tables (A, B, C) using Power Query or SQL views. This reduces the risk of data loss from inner joins and improves performance.

Introduce a centralized Date table and map your entities using a valid-from/to structure in a separate mapping table. Use DAX functions like TREATAS() or USERELATIONSHIP() to apply custom date filters without expanding millions of rows at runtime.

Avoid direct many-to-many joins by using bridge tables or by pre-processing the mappings into your model to reduce relationship complexity. When handling large historical data, split the model using composite mode: recent data can be imported for fast access, while older records can be accessed via DirectQuery or summarized tables.

Wherever possible, push filtering and bitemporal logic into the data source to avoid expensive transformations in Power BI. Avoid using DAX-generated values in slicers; instead, build static slicer tables with predefined time ranges or categories.

Finally, leverage incremental refresh for long-term datasets to prevent full refreshes and maintain efficient query performance.

This combined modeling approach should provide a more maintainable, scalable, and performant solution. Let me know if you'd like help structuring this with sample schema or visuals.

If all your tables are in import mode, you can use Power query to prepare your data.
You can follow these steps-

1. Import all your bi-temporal tables.
2. Create all possible ID-Date combinations (through calendar table cross join).
3. Merge tables one-by-one using Left Joins based on:
   ID match
   

   Date between From and To

This results in a flattened structure where unmatched data from newly introduced tables will result in nulls, not blanks.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.