Date columns in Power BI are generally recorded in Date or Datetime formats. which means the day, month, and year (and time) are in one column in dd-mm-yyyy or similar formats. In case we need one element from the date column we need to extract it from the column. We can do that in Power
Getting a simple bookmark button pair working together is easy in Power BI. Here is how you do it. In this, we discuss how to use, Button to hide a simple object. Let’s try with a simple object and a button. When the user clicks the button, the square object hides and when clicked again
PowerAutomate Desktop is a separate tool from PowerAutomate Web that we can use to create and run desktop flows on a computer. While PowerAutomate is available on the web as one of Office 365 apps, the desktop version needs to be separately installed before we create any flows. Let’s see how to install PowerAutomate Desktop
Ideally, the drop-down is supposed to show only unique items of assigned columns and filter according to the selected item. But, when a non-unique column is assigned to a dropdown on Powerapps, it doesn’t automatically show only distinct values. In this post let’s find out how to do that. Scenario for example, let’s say we
Removing data is a crucial step When cleaning data of any new data set. It’s essential in any dimension table to have unique values to be able to create one-to-many relationships on power bi. In addition to that, it’s useful to get only unique values at any stage of the data visualization process. In this
We can go down 2 paths to get the current date or current DateTime in Power Automate. How do I get today’s date and time without writing a formula? This is the easiest method, and you don’t have to compose any formula. There is an inbuilt action on Power Automate to get today’s date and
If you’re stuck with a syntax error and looking for the short answer, here it is. IF function (DAX) – DAX | Microsoft Learn Let’s move on to the long answer. IF Statement in a Custom Column with one condition You can use an if statement in a custom column with one condition, multiple conditions,
If you’re stuck with a syntax error and looking for the short answer, here it is. Let’s move on to the long answer. Can I use the IF statement in the Power query? Yes. you can use an if statement in Power Query but the syntax is slightly different from what it is in DAX.
Introduction Let’s split this generic linear sale data chart into multiple line charts by year (months or quarters ). Sales data for the first example, we have a generic sales dataset. It has Order date and Profit etc columns plus 4 years’ worth of data. We can add these 2 columns to a line chart
Getting a running average in Excel is pretty easy. You just need to add the last 12 cells in the AVERAGE ( ) formula and autofill the table would do the trick. In Power BI, however, it’s a little bit tricky. In this post let’s find out how. The DataSet Table of sales values of