Week to Date Calculation in Power BI with DAX

There are a number of pre defined DAX time intelligence calculations that help you to get analytics over time, such as year to date, same period last year, and etc. However, there is no calculation for Week to Date built-in. I have found it quite a demand for some of businesses, as many of businesses Read more about Week to Date Calculation in Power BI with DAX[…]

Quick DAX : Convert number to binary (and back)

Something that is currently missing in DAX is a native set of functions to perform Bitwise operations.  These can be incredibly useful functions and one, in particular, is the ability to convert a  base10 number to its binary format. Once you have the number in binary format, you can apply logical operations between numbers to Read more about Quick DAX : Convert number to binary (and back)[…]

Azure data Bricks – Part2

In the last post, I have explained how to work with Azure Databricks. In this post, I will show: 1- Upload data in Azure data Lake Store 2- get data from Azure Data Lake Store into Azure Data Bricks 3-clean Data with Scala language 4- visualizes with R language 5- Predictive Analysis with R In Read more about Azure data Bricks – Part2[…]

Quick DAX: Use GENERATESERIES to create Time buckets

A not so obvious use of the recently added GENERATESERIES function to use it to generate time buckets.  The more common use of this function is to generate series of numbers, but it works just as well with Time based data. Say you want to create a data table with rows that represent time periods.  Read more about Quick DAX: Use GENERATESERIES to create Time buckets[…]

Azure data Bricks – Part1

Databricks is an analytics service based on the Apache Spark open source project. Databricks has been used for ingesting a significant amount of data. In February 2018, there is integration between Azure and Databricks. This integration provides data science and data engineer team with a fast, easy and collaborative spark-based platform in Azure [1]. Azure Read more about Azure data Bricks – Part1[…]

Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables

I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the version 2.0 of this product is now available for everyone to use and enjoy. This version comes with Read more about Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables[…]