Power BI: Use DAX to get relative dates
Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a...
2019-05-15
Patrick looks at how you can get relative dates, in Power BI Desktop, without using the relative date slicer or relative date filters. You just need to sprinkle a...
2019-05-15
Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in...
2019-05-14
2019-05-13
How can you find the cause of slow performance issues in Power BI? This post demonstrates some of the advanced tools you can you to test slowing performing queries...
2019-05-11
This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code easier to read and maintain. Using...
2019-05-11
The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article, Dennes Torres explains how to add a slicer that does the job.
2019-05-09
A BI project should return value to the company quickly, not only after months or even years of work. In this article by Gogula Aryalingam, Ruthie, the intern, determines which items from her manager's requirements she can complete before the big meeting. She continues working on her semantic model by including a Date table, the star schema, measures, formatting, and more.
2019-05-06
The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate, filtering it is not so straightforward. In this article,...
2019-04-15
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup133 2 Minute Tuesday: https://guyinacu.be/pbireportbuilder Patrick's tech video: https://guyinacu.be/kpicard Adam's tech video: https://guyinacu.be/newworkspace Sources MICROSOFT’S POWER PLATFORM...
2019-04-15
Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a...
2019-04-15
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
I have the user Managed identity <myusermanagedidentity> , granted it carte blanche alter...
First off, my apologies for what could potentially be a bad title! I am...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers