top of page
![DataZoe Power BI](https://static.wixstatic.com/media/991134_6cf2cc236ac141f7bc9d6bc3b93c4658~mv2.png/v1/fill/w_268,h_93,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/logo_transparent_background.png)
Search
![DAX Date table in Power BI shown in TMDL View](https://static.wixstatic.com/media/991134_0facc16df8e84421adfbd1ccd394186f~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_0facc16df8e84421adfbd1ccd394186f~mv2.webp)
DataZoe
26 minutes ago5 min read
DAX Date table in TMDL
My date table now in TMDL with sort by columns, format strings, descriptions, folders, and hierarchy.
1 view
![DEFINE MEASURE in a DAX query of DAX query view in Power BI](https://static.wixstatic.com/media/991134_ee6e42a68d46437d929762e873d7006f~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_ee6e42a68d46437d929762e873d7006f~mv2.webp)
DataZoe
6 hours ago7 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...
94 views0 comments
![DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}](https://static.wixstatic.com/media/991134_9acd89e56cf4431fbe8d81fbdf689842~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_9acd89e56cf4431fbe8d81fbdf689842~mv2.webp)
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!
900 views
![Setting up RLS on a Direct Lake semantic model](https://static.wixstatic.com/media/991134_03bace0eee3940dca530ecf093f6fb85~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_03bace0eee3940dca530ecf093f6fb85~mv2.webp)
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...
6,409 views0 comments
![Generate a Power BI Direct Lake data model in Fabric](https://static.wixstatic.com/media/991134_30a642e736f14fd6b22931a4192605ee~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_30a642e736f14fd6b22931a4192605ee~mv2.webp)
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,047 views0 comments
![DAX Date Table](https://static.wixstatic.com/media/991134_3656ca153a294c6aaf2fb2b2f9327123~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_3656ca153a294c6aaf2fb2b2f9327123~mv2.webp)
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,820 views
![Report overlay to highlight report features](https://static.wixstatic.com/media/991134_7dbcd62244ca49329be8466ee90dc0a4~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_7dbcd62244ca49329be8466ee90dc0a4~mv2.webp)
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,661 views0 comments
![Buttons to highlight a selected measure!](https://static.wixstatic.com/media/991134_2574bc5161f34711b970cc48c1f5e658~mv2.webp)
DataZoe
Apr 10, 20213 min read
Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!
1,886 views0 comments
![Working with DateID in Direct Query and Incremental Refresh](https://static.wixstatic.com/media/991134_d9bb208367904ead8dc53884cc5bee21~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_d9bb208367904ead8dc53884cc5bee21~mv2.webp)
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
259 views0 comments
![Creating a slicer panel!](https://static.wixstatic.com/media/991134_b5ea91b1e7ac430e938a1a24778f9e62~mv2.webp)
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,286 views0 comments
![Let's create a data model!](https://static.wixstatic.com/media/991134_34f67543ca234dc5b94c3457c94b0449~mv2.png/v1/fill/w_454,h_341,fp_0.50_0.50,q_95,enc_auto/991134_34f67543ca234dc5b94c3457c94b0449~mv2.webp)
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....
813 views0 comments
bottom of page