dax formulas

Hi everyone 😊 I still have a lot to learn about DAX and have become stuck trying to develop a measure that will filter down my source table to a single row by using values in two columns and return the (text) value from a different, specified column. I have two measures that filter a table and...

Hi I am building a dashboard for survey data and for reasons I am not quite sure I am running into a couple of problems. I have five questions that I want to focus on. My dashboard looks like so: 1) I wrapped the text box at the top with a blank box that i removed the borders. When I...

Hello everyone, I would like to ask you for help with a problem I have with a calculated column 22VS21. what I wanted was that the column 22vs21 = (2022 values - 2021 values) / 2021 values the calculations should result to client 1 22vs21 = (300 - 200) / 200 = 0,5 the table with the...

Hello, I have the Dax code below. All works fine except the code after RETURN. I am working with Dax Studio. I want to return list of Customer IDs in 2014 that are not in other years. Kindly help resolve. Thanks EVALUATE VAR main_table = SELECTCOLUMNS(Orders,"Order Dates",Orders[Order...

I am trying to build out a DAX RANKX formula that will rank Employee ID by Profit. Here is the formula I have today see below... However, this formula messes up when I start to layer in multiple dimensions into rows. Rank - DO Profit by Employee:=IF(ISBLANK([DO...

I am trying to find Employee turnover by Year/Company I have and employee table and I have created a Calendar table The employee table has the following columns ID Hire Date Term Date Company Active Status I would like to createa dashboard to show by Company turnover % by Year (2018 &...

Hello everyone! Hope you can help me on this Here's the problem: I'm trying to automate wih power BI something that takes me 4 hours to do. In a first source I get the following information (Excell file) * Reference number * Reference date * Customer * Country * Duration in minutes * Number of...

Here is picture of needed data. There is a piece of data (table 1). Primary data starts with March 2010 and I filtered it by Employee 1 and Employee 100. As you can see Employee 1 was not at the Project in May and December, so in May Total Expenses change was -$700. One part of my task is to...

Hi, I don't have experience with DAX and I'm trying to understand a DAX which is used in a workbook. Here is the link to workbook. https://community.tableau.com/servlet/JiveServlet/download/847360-289331/SampleData.xlsx This is the formula which is used to calculate earned exposure. =SUMX...

Hi all, First up, I have posted this query on another forum https://powerpivotforum.com.au/viewtopic.php?f=6&t=1305 I am working on a dashboard that can track all the projects that are currently being undertaken. The aim is to report on the progress of the various projects over a period of...

I can't tell if the image is loaded. Here's the url: https://imagebin.ca/v/4DD95zPeoS5p Anyway, sum is sum(Table1[value]) maxmo is max(xmonth) measure 1 is if([maxmo]<12,divide([sum]*12,[maxmo],[sum]) How do I get the subtotal at line 1 to equal 48.8 and not 44. I understand why its 44, but I...

I am truing to use filter in specific order, first filter out all sub accounts to 100 and than find max year_dt, can someone please help me with the expression? Thanks Z Calculations:=CALCULATE( SUM(Inv2018T[Custom]), FILTER(...

I have this sort of table below and I'd like to calculate percentile 80 to "qtd/cons" for each category in "Col1" as a calculated column. Col1 qtd cons qtd/cons <tbody style="border: 0px...

Hi I have a measure to calculate % Growth, but I find I'm getting some large results. I would like to limit the result to be between -999% and +999% in my visuals as these tend to be outliers. In Excel I can do this using a combination of MIN and MAX (eg =MIN(999, MAX(-999, calculation))...

In Excel I can perform a lookup that uses the desired column for the return value by varying the column in the formula. How can this be done on either the Query side or the PowerPivot side of PowerBI?

I was trying to create a DAX formula to show only the value of a particular line, however that number repeats all the way down. See image attached below. I have a calculate formula and have defined the parameters, but that number get repeated everywhere... I only want it to appear once in the...

Hi, I'm new to power pivots and dax formulas. Does anyone know how I can work out the average value of distinct count based on a criteria? Let's assume I have the tables below Customer Table Customer - Region a - AA b - AA c - BB d - CC Product Table Product - Type 1 - X 2 - X 3 - Y 4 - Z...

All, We have 3 different kinds of M2 calculations: Bruto, Netto and SuperNetto. To make the calculation intelligent, we made one M2 calculation which uses the Netto M2 as a default. In parallel we have a member (Calculation Type) which contain all the M2 kinds (Bruto, Netto and SuperNetto)...

Hi I'm look to get the MTD sales for the same days last year. IE May 1-8 of 2016 vs. May 1-8 2017. Or in a perfect world May2-9, 2016 vs. May 1-8, 2017 This gives me all of May last year: 1 YR AGO SALES NET RETAIL:=CALCULATE('tblInvSkuMaster'[SALES TOTAL NET...

Hello!, Please I ask fro support in applying function for specific element DAX. I Have a column called LOB, contains 11 elements "Criteria" <tbody> LOB Business Golden Customers NC Reapers TEData-Sales TEData-Sales "Subscription" WE Xceed-UP Q Xceed-Basic Xceed-Sales...