dax

I would like to create a series of measures that shows my current week's sales by day. Example: 1 measure shows Sunday's sales, 1 measure shows Monday's sales, etc. In order to identify the current week, I have added a field to my date table called 'Week Rank' in combination with the max...

I am attempting to create a Power BI measure that computes the number of active employees and that can be sliced by date, based on a table that is a running list of employment changes. As a sample data set: Employee ID Change Date Status Title Change Reason A 1/1/2021 Active Director of...

I am analyzing data about employee headcount and I am looking for a way to simplify my formulas. My end goal is to be able to have measures that give me headcount on a given date, how many employees were gained between the given date and the previous month, how many were lost between the given...

Hi Team, So, I have a power Bi task at hand where I have created a dashboard . Issue is I need to display average of a calculated column by month for eg; I have a column with name CSM readiness CSM readiness = csm1 + csm 2...

Hi, I need to calculate the voluntary attrition for employees who left the company within less than or equal to 6 months of their hire date. How would I accomplish this? I have below fields and tables: - Attrition Table that has below fields: - Employee ID - Hire Date - Term Date - Term...

Hi All, I have a table below for which I need to change the background color for the values using DAX measure in conditional formatting. I have also added the output image with the conditions that I want to apply in the measure. I have already tried the measures that are already mentioned in the...

I have data in the format below (minus the far right column) EmailAddress CourseTitle Complete AllComplete 1@1.com Course1 true false 1@1.com Course2 true false 1@1.com Course3 false false 2@1.com Course1 true true 2@1.com Course2 true true 2@1.com Course3 true true Using DAX...

Hello all, I know there's a lot of stuff out there about CALCULATE, but I wonder if someone can point me in the right direction, I've created a running total by each month using DAX as a calculated column. I've also got the same as a measure , the difference is the definition of the variable...

Hello all, I want to create a running total by product category in power query; so far I've come up with the following; <VAR prod = TESTA[Product] RETURN CALCULATE(SUM(TESTA[Qty]),FILTER(TESTA,TESTA[Index]<= EARLIER(TESTA[Index]) && TESTA[Product] = prod))> variable name pod ...

Hi All and welcome to the forum, I’m looking for help in writing the formula for the below business case. First, let me give you an overview of the dataset and what I need to calculate. Data Data set is a table that is a result of appending hundreds of reports. There are two relevant...

Hi, I'm using the below code to retrieve amounts on the last posting date. LastPeriodSelected = CALCULATE ([FinanceAmountMeasure], FILTER ('Date', 'Date'[Date] = max('Consolidated Accounts'[PostingDate]))) I have a filter on the visual on the current year and selected months. My question...

I created a report in Excel using PowerPivot that shows how many of each part number are needed each day to fulfill customer orders. To do this I pulled 2 tables from our ERP database. (The data below is simplified for this example but should convey what data is available.) 1st: The part table...

I'm looking to optimise the following measures with the aim of creating a pivot table containing 'MyValue' and a grand average 2 point moving range centre line (the AverageMovingRange measure below). Because various other fields can be added as filters, as well as ID being grouped by fields...

Hello, I am trying to create a column in PowerBI that takes the cumulative sum of a table column of numbers, *but*, if in any row the value of that sum is exceeded by a number in a secondary column, the cumulation is replaced with that secondary number. The cumulative sum would then carry on...

Hi all Regard to Calculating days of supply using DAX... thread I would like to ask you for help. I need to calculate Days of Cover. Data structure is following: WeekDate, Product, ClosingStock, Demand. I tried to use the code from previous thread but I hit on problems. First one is on the line...

Í'll try to explain with data table/power pivot. I want to split the intervals (without ", ") in the column SectionS (plural!) giving each interval it's own column (with corresponding section as name) into a (power) pivot table. I guess using DAX is the only way... but how? I'm no Ferrari ;)...

Hello All, I have been trying to replicate excel Sumifs in Power BI without much luck. I have below excel data and a summarised table. The Table on the right in excel is essentially doing sumifs based on filter selection. For e.g. Sum of Volume for Customer =Cust 1, Product=Hat 1, Plan =A...

Hi I have a table, key fields being: retailer_name order_ref_id order_date payer_status I have the following DAX measure: Perc Orders By Payer Status by Retailer = var SelectedOrders = COUNT(conversion_loan_collection_order[order_ref_id]) var SelectedRetailerOrders =...

Hi there, I am currently using the following two measures with a power pivot table: Sales Count =DISTINCTCOUNT(SalesHistory[Transaction ID]) Sales Frequency (return a “2” if there are at least 3 sales instances, “1” if instances of sales is between 1-3, “0” if no sale) =if([Sales...

I am building a dashboard to show progress of employees through a long-term training program. I am trying to create a measure to track progress against time-based expectations, and I'm struggling with the DAX logic. The model I have is a variation on a star schema. The central table is a record...