DAX has many functions to write conditional expressions. For example you might want to calculate sum of sales amount for all “Red” products. you can achieve it by using SUMX or Calculate, and functions such as IF or Filter to write a conditional expression for product color to be equal to “Red”. At the first Read more about IF and Filter are Different! Be Careful (DAX)[…]
In previous posts, I have showed the process of creating a live weather data streaming with Cortana. In Part 1 the process of setting up Raspberry PI3 and weather station sensor has been explained. Following, in Part 2, the process of setting up the Event Hub as a median to digest the data from Raspberry PI Read more about Part 4 – Live Streaming Weather Station with Cortana Analytics (Online Data Analytics with Azure ML)[…]
In previous posts (part 1 and part 2), I have explained the process of data live streaming. In the first post, I have explained the process of setting up the Raspberry PI 3 and Weather station. In the second one, I have explained the process of setting up the Event Hub that helps us to. In Read more about Live Streaming Weather Station with Cortana Analytics – Part 3[…]
I have previously written some blog posts about Map visuals in Power BI. One of them was specifically about Filled Map, titled as Filled Map; the Good, the Bad, the Ugly! Why? you need to read that post to find the reason. In this post I want to explain the power of Shape Map which Read more about Shape Map Better than the Filled Map[…]
There are many ways to share Power BI content with others. I have previously written about some of these methods, including Workspaces (or groups) in Power BI, Publish to Web, and Power BI Embedded. In this post, you will learn about organizational content pack which is another method of sharing. This method is a recommended Read more about Content Pack; Sharing, Self-Service and Governance Together[…]
What is the main difference between M and DAX? Why we can do a calculated column in two different places? What are pros and cons of each? Which one should I use for creating a profit column? Why I cannot do all of it in only one; DAX or M! Why two different languages?! Why Read more about M or DAX? That is the Question![…]
Cortana analytics help organization to transform data into intelligence. In this post I will show how to use Cortana Analytics for IoT and Machine Learning Purpose. In propose scenario I will try to show some components of Cortana intelligence that has been used for collecting data from a weather station sensor and show the live temperature data Read more about Live streaming Weather station with Cortana Analytics – Part 1[…]
It has been a long time request in my blog posts to release the book in PDF format, and here you go; Free PDF format of Power BI from Rookie to Rock Star book edition 1 is now available. You can download and print it for free! However, this book has 905 pages, which make Read more about Download Free Power BI book PDF Format[…]
Thanks for all attendees of my webinar yesterday in PASS Business Analytics Virtual Chapter (Group). It was a pleasure to present to you all again. The session time spent all for me speaking and there was no time for answering questions at the end, so here I’ll answer all questions, and you will have access Read more about Materials and Q&A of PASS BA VC Session: Take Power BI Visualization to the Next Level[…]
I have written a blog post while ago about using Edit Interaction to control the interaction of visuals. There are however sometimes that you want to have some of filters to be applied on (some measures) of a single visual, but others not. In this post I’ll explain one method of writing DAX expressions in Read more about Overwrite Interaction of Power BI with DAX[…]