top of page

Search

DataZoe
Feb 175 min read
DAX Date table in TMDL
My date table now in TMDL with sort by columns, format strings, descriptions, folders, and hierarchy.
1,650 views

DataZoe
Feb 167 min read
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...
835 views
0 comments

DataZoe
Jan 2616 min read
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!
1,375 views

DataZoe
Jan 18, 202410 min read
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...
7,029 views
0 comments

DataZoe
Jul 10, 20236 min read
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...
1,076 views
0 comments

DataZoe
Jul 31, 20212 min read
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...
1,951 views

DataZoe
Jun 10, 20214 min read
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.
1,716 views
0 comments

DataZoe
Apr 11, 20213 min read
Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!
1,912 views
0 comments

DataZoe
Jan 30, 20214 min read
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
260 views
0 comments

DataZoe
Dec 20, 20203 min read
Creating a slicer panel!
Many of my reports feature the slicer panel that hide/show on via a button.
1,302 views
0 comments

DataZoe
Dec 4, 202011 min read
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....
820 views
0 comments
bottom of page