/explore
|
You are here 
|
eriksvensen.wordpress.com | ||
| | | | |
devinknightsql.com
|
|
| | | | | A date dimension or table can be extremely important when working on a Power BI project, or BI projects in general for that mater. Here's some of the quick benefits and reasons why you need a date table: Helpful when filtering data Filter by year, quarter, month, etc... Helpful for drilling into a hierarchy of... | |
| | | | |
www.fourmoo.com
|
|
| | | | | This blog post I will demonstrate how to change a DateTime column data type to Date dynamically. You might be wondering what I mean by dynamic, this means that I will not specify any actual column names. The code will find the column names based on their data type. For me this has been a challenge to get it working,... | |
| | | | |
datasavvy.me
|
|
| | | | | I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks Unity Catalog. I didn't have access to add more fields to the view, so I was adding the fields in Power Query first, with plans to... | |
| | | | |
curiousaboutdata.com
|
|
| | | I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given that most of the community is no longer on X/Twitter and my invite didn't seem to get much attention. I was wrong. People seem to keep... | ||
