---
title: "Discussion on \"Comprehensive Date Dimension Table For Power BI Datasets in Fabric\" | Hashnode"
description: "Discussion on \"Comprehensive Date Dimension Table For Power BI Datasets in Fabric\". Creating date dimension Delta table using pandas and pyspark for time intelligence calculations in Fabric"
url: "https://hashnode.com/posts/comprehensive-date-dimension-table-for-power-bi-datasets-in-fabric/646f6ff9861e784832cfcfb0"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Comprehensive Date Dimension Table For Power BI Datasets in Fabric](https://fabric.guru/comprehensive-date-dimension-table-for-power-bi-datasets-in-fabric?utm_source=hashnode&utm_medium=feed)

Creating date dimension Delta table using pandas and pyspark for time intelligence calculations in Fabric

May 25, 2023 · 3 min read · fabric.guru  
Updated Jun 15, 2023  
Read the article

-   [#directlake](https://hashnode.com/tag/directlake)
-   [#fabric](https://hashnode.com/tag/fabric)

## Written by

[Sandeep Pawar](https://hashnode.com/@PawarBI)

@PawarBI

  
[View profile](https://hashnode.com/@PawarBI)

Building Data Analytics and Data Science solutions using Microsoft Fabric | Principal PM, Microsoft Fabric CAT

Principal Program Manager, Microsoft Fabric CAT helping users and organizations build scalable, insightful, secure solutions. Blogs, opinions are my own and do not represent my employer.

## Responses 2

Markdown supported · ⌘↵ to post

[Dean J](https://hashnode.com/@djurecic)

[Jun 24, 2025](https://hashnode.com/posts/comprehensive-date-dimension-table-for-power-bi-datasets-in-fabric/646f6ff9861e784832cfcfb0/comment/685aed6b1c9b314d89b8196e)

Thanks for this article! Can you pass parameters for start and end dates?

[Chris Jones](https://hashnode.com/@cjfjones)

[Apr 19, 2024](https://hashnode.com/posts/comprehensive-date-dimension-table-for-power-bi-datasets-in-fabric/646f6ff9861e784832cfcfb0/comment/662235cc9447d96aad4ccec3)

Not sure if your experience was different, however I had to drop the .date off the following two statements to work correctly as the comparison wasn't returning true for Today.

df\['IsTodayFlag'\]=(df\['Date'\] == today).astype(int) df\['IsToday'\] = np.where(df\['Date'\] == today, 1, 0)

Hope this helps - Chris Jones