Combining Tables in Power BI: Union, Except, and Intersect in DAX

Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except, and Intersect in DAX[…]

Solving DAX Time Zone Issue in Power BI

Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read more about Solving DAX Time Zone Issue in Power BI[…]

Power Query; Convert Time Stamp to Date Time

Power Query has number of Date and Time functions that convert values to date and time. However I haven’t found a function that converts a timestamp value. Fortunately it is easy to calculate a date time from a timestamp value. In this post I’ll explain an easy way of converting timestamp to date time. To Read more about Power Query; Convert Time Stamp to Date Time[…]

Power Query Not for BI: Event Date and Time Scheduler – Part 3

Previously You have seen in Part 1 and Part 2 of this series, that how you can use Power Query to do data transformation and turn the result of event date/time scheduler of timeanddate.com website to a better format. We’ve used number of basic transformations, and some functions such as Table.Transpose to fetch desired output. Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 3[…]

Power Query Not for BI: Event Date and Time Scheduler – Part 2

In first part of this series I’ve explained that Power Query can be used for non-BI scenarios, and here is a real-world use case example; Creating an event date and time scheduler which consider multiple time zones. In previous post you’ve learned how to use Power Query to do some data mash up to build Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 2[…]

Power Query Not for BI: Event Date and Time Scheduler – Part 1

Previously you have read how to use Power Query as the data transformation component of Power BI and you learned how to use it in BI applications. You can read more about Power Query usage in BI in Power BI online book from Rookie to Rock Star. In this series I will explain how to Read more about Power Query Not for BI: Event Date and Time Scheduler – Part 1[…]

Row Level Security in Power BI; Regardless of Data Source

Almost couple of weeks ago Power BI update added the new functionality in security. This functionality enables you to apply row level security to roles and add users under each role. This is really helpful when you want people from one branch, city, department, or store to be able to only see their part of Read more about Row Level Security in Power BI; Regardless of Data Source[…]

KPIs and Power BI; Visualization Aspect

In every reporting solution you might feel KPI as a requirement. KPI or Key Performance Indicator is a measure for business to understand how they are acting in specific area that is very import for their business. Power BI supports built-in visualization for KPI, and there are also some good custom visuals that can be Read more about KPIs and Power BI; Visualization Aspect[…]

Step Beyond the 10GB Limitation of Power BI

Power BI free allows you to have 1GB data per user, and pro 10GB. However in many organizations you have much bigger size of data than 10GB, sometimes you deal with Tera bytes, even Peta bytes of data. Is Power BI limiting you for the visualization? Short answer; No! In this post I’ll explain you Read more about Step Beyond the 10GB Limitation of Power BI[…]