/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... |
|
| | | | | ||
| | | | |
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... |
|
| | | | | ||
| | | | |
querypower.com
Regardless of your requirements, providing someuser contextduring slicing of data ora filtering mechanismfor data querying, having a function like USERNAME() in Power Query toolbox can greatly simplify your data mashup scripts. While trying to build a more robust approach forself referencingqueries in M, I've managed to collect four methods for getting the current username in... |
|
| | | | | ||
| | | | |
tsqltuesday.azurewebsites.net
[AI summary] An invitation to participate in T-SQL Tuesday #86 by discussing SQL Server bugs and enhancements found on the official Connect site. |
|
| | | |||
