What is the Difference Between FILTER and CALCULATETABLE?
What is the Difference Between FILTER() and CALCULATETABLE()?
top of page
The Antares Alien
Power BI
The Antares Alien
Power BI | DAX
Blarg! Here, I write about Power BI stuff in a fun and unique way. I also occasionally write about video game development. Thanks for checking out my blog!
Search
Brent Jones
- Feb 11, 2023
Using a Custom Function Within List.Generate()
Looping with the M language is not easy. What if you want to loop a custom function and break out of the loop based on the functions return
1,725 views
Brent Jones
- Oct 6, 2022
Calculating Business Days and Hours Between Two Dates (DAX)
Power BI DAX has a function called "NETWORKDAYS()". However it does not calculate hours. If you need to calculate hours, you can use this...
2,159 views
Brent Jones
- Aug 7, 2021
Power BI: How to Remove Duplicates and Keep Most Recent?
How to remove duplicate records while ensuring that you keep the most recent item?
20,247 views
Brent Jones
- Oct 28, 2019
Displaying Unity's Game Build Log
If you ever want or need to display Unity's build report with graphs and charts, you can do that with Power BI. The set up takes a coupl
1,677 views
Brent Jones
- Jun 8, 2019
Exploring "Overtourism" with Power BI (Part 1)
The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including A
201 views
Brent Jones
- Apr 26, 2019
Power BI's "Automagical" Column From Example Feature (for any web page!)
Power BI has a somewhat hidden feature you may not have know existed - or maybe you knew about it but haven't given it a thought to try
93 views
Brent Jones
- Dec 18, 2018
Want to Build Your Own Neural Network With Python?
Book review for "Make Your Own Neural Network" by Tariq Rashid. Excellent job of explaining the concepts in an easy-to-understand
40 views
Brent Jones
- Oct 29, 2018
Power BI: Ultimate Guide to the Basics of Importing Data
To begin, click on the "Get Data" button on the Home tab of Power BI. This will bring up a new window with several options.
153 views
Brent Jones
- Sep 21, 2018
Get Worksheet Data In the Current Workbook With Power Query
You may already be familiar with the "Get Data" function in Excel. You can use this feature to send data from your worksheet to Po
27,195 views
Brent Jones
- Aug 13, 2018
Power Query: Preventing "The column of the table wasn't found" error
Read about how to prevent errors resulting from column name changing.
53,843 views
Brent Jones
- Aug 9, 2018
How to Make a Cells Value a Power Query Parameter
Create easily editable parameters in Excel for Power Query to help your users. Use a named range in Excel for the query source. You can then
6,830 views
bottom of page