top of page

Search


DAX Date table in TMDL
My date table now in TMDL with sort by columns, format strings, descriptions, folders, and hierarchy.

DataZoe
Feb 175 min read
1,873 views


DAX query 102: DAX formulas and measures with DEFINE MEASURE
There is a now a DAX query view in Power BI and let's get you started querying your data with whatever formula you need defined in the...

DataZoe
Feb 167 min read
1,005 views
0 comments


DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}
Let's get you started querying your data to get the analysis you are looking for!

DataZoe
Jan 2616 min read
1,790 views


Setting up RLS on a Direct Lake semantic model
Power BI semantic models have the option to set up row level security (RLS). And this includes Direct Lake Power BI semantic models in...

DataZoe
Jan 18, 202410 min read
7,774 views
0 comments


Generate a Power BI Direct Lake data model in Fabric
One of the cool things about having a notebook inside a Power BI workspace is all the cool things pyspark can do. I wanted a way to...

DataZoe
Jul 10, 20236 min read
1,096 views
0 comments


DAX Date Table
There are a lot of different Date tables out there, and this is mine! This one features things I add in many of my reports, which is a...

DataZoe
Jul 31, 20212 min read
1,972 views


Report overlay to highlight report features
When I show a report to someone, I find myself pointing to parts of the report and explaining what they do, here I add an overlay to do it.

DataZoe
Jun 10, 20214 min read
1,753 views
0 comments


Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!

DataZoe
Apr 11, 20213 min read
1,926 views
0 comments


Working with DateID in Direct Query and Incremental Refresh
Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat

DataZoe
Jan 30, 20214 min read
264 views
0 comments


Creating a slicer panel!
Many of my reports feature the slicer panel that hide/show on via a button.

DataZoe
Dec 20, 20203 min read
1,316 views
0 comments


Let's create a data model!
Tabular data modeling is key to making a report, and can be daunting at first. I'll show you how I approach making a tabular data model....

DataZoe
Dec 4, 202011 min read
833 views
0 comments
bottom of page