In this Blog, I will show you How to select Max Date and Max Time for the Date. I have this kind of table: CREATE TABLE Dateandtime1( [Date_updated] [date], [Time_updated] [Time] ) We can create two columns that have both date and time…
Still haven’t empowered your business with Microsoft Power BI? Hurry up! Microsoft Power BI is a set of Business Intelligence tools used by organizations to help them gather important data, visualize and analyze it to form creative and understandable reports for decision-making. Power BI is…
Hi Readers , have you ever wondered on how to run a Machine learning Model (in python) in Powerbi application? This Blog will help you with it.Before Implementing it you need to have a ML model in python code ready. In my case, I have…
Hi everyone! As you know tables and matrix visuals are the most go to visual for any Power BI Report. And there may be a chance where you may have a requirement to display the totals right to the header side of the matrix visual.…
Alerts and Notification are great features provided by Microsoft Power BI for their report users. You will get an alert or notification when the value goes above or below the threshold. You can use these features on KPI, Cards, and Gauge visuals on Power BI…
I worked on a dataset connected through Web API. Multiple tables are appended and used in the report. I got the below mentioned error while refreshing manually and scheduled in Power BI service, but it is refreshed in power BI desktop without any error. Processing…
This is a small blog explaining the DAX expression to count multiple column values into a single column. Here we have a sample table Table1, which has columns named ID, Dim1, Dim2, Dim3 and Dim4. The columns Dim1 to Dim4 has the values “Yes” or…
This blog is explaining different methods to connect D365 & Navision data with Power BI Connect Power BI with BC using Dynamic 365 Business Central connector In Power BI Desktop, choose Get Data > Online Services > Dynamics 365 Business Central > Connect. Sign in with the same account you used…
Hi everyone, in this blog we are going to learn about different types of Analytical lines in PowerBI. Let’s get started. We have a data which talks about Sales of Various different products. You shall see a glimpse of it down below: Our objective is…
Hi there, in this blog we are going to learn about Percentile function in PowerBI. Let’s look at the basic data below: Before we start, I would like to mention about Quartile. What exactly it is? Let’s say we have numbers from 1-100. If we divide…
