In the previous post (Working with Date – Part I), I wrote about calculated column for month and year and in this post I will explain how to work with day and week formats. As prerequisites, your Power BI model needs to have a Date table, which will be used to create a couple of … Continue reading Power BI – Working with Date – Part II
Category: DAX
Power BI DAX Percentage
There are a couple of ways in Power BI to create a chart to show percentage and I am writing this post to show few different ways to accomplish it. I am using a few tables from AdventureWorks 2016 CTP3 database, as below: For testing propose, I will use Line Total (Sales Order Detail Table) … Continue reading Power BI DAX Percentage