If you are finding a solution for Excel, please read this post. https://summalai.com/?p=3964 Below by Stephanie Bruno One of the unsung heroes to me in Power BI desktop (or Power Query in Excel) is how wonderfully simple it is to combine csv or Excel files from a folder. Maybe it’s not totally unsung, but I Read More
Category: Power BI
How to Fix “A function ‘CALCULATE’ has been used in a True/False expression that is used as a table filter expression. This is not allowed.”
Sample problem: I’m looking for a more elegant way sum based on a prior business day calculation. The following *does work* but will get a little more cumbersome when doing MTD or YTD calculations: Prior Day Invoiced = CALCULATE(sum(‘Sales Ledger Transactions'[Net Sales]),’Sales Ledger Transactions'[Fact Attributes.Source Sale Type Code] = “INVOICED”,‘Sales Ledger Transactions'[Date.Date] = (if(weekday(today(),1)=1,today() – Read More
How to Create Forward Forecasts
In this blog, we’re going to go over how you can create automated forecasts from historic data in Power BI. This is common in businesses to make forecasts and budgets. You may watch the full video of this tutorial. Now, have you ever wanted to create automatic forecasts based on historical information? In the past, this was relatively difficult to Read More
How to Create a Calculate Column for The Same Day of Last Year
You can create a calculated column in Calendar Dimension: SameDayLY= var TodayDate = TODAY() var LastYear = YEAR(TodayDate)-1 var LastMonth = MONTH(TodayDate) var LastDay = DAY(TodayDate) return ‘Calendar'[Date]= DATE(LastYear,LastMonth,LastDay) This solution shoule be good for most of the situation. However, your way returned a true value for “2019-03-01” if Today date was a Leap day Read More
How To Set Tab Order In Power BI Desktop
What is Tab Order? Tab order is the order in which users interact with the items on a page using the keyboard. Generally, we want tab order to be predictable and to closely match the visual order on the page (unless there is a good reason to deviate). If you press the tab key in Read More
How to Build a Power BI Dashboard for Mobile Correctly
4 steps to build Power BI dashboard for Mobile correctly In this article, we will learn how to Optimize a Power BI dashboard for mobile phones. What is a Power BI dashboard? How to create a power bi dashboard for mobile phones? What is a Power BI dashboard? A Power BI dashboard is a feature of the Read More