dax formula

Hello, For certain products, we have a variable pricing concept and through a power pivot table we're trying to determine - by product (row) - for every sales price (value) the mean, deviation from mean and standard deviation. We use measures in the pivot table to come to the standard deviation...

Looking for some help with a DAX formula to calculate the WoW percent change. I have the formula below but the card visual doesn't have any value displayed and I cannot figure out my error. Any help is much appreciated. % Change Sales = VAR CurrentValue = SUM('Sales'[Units]) VAR...

Hi guys, I have a rolling calendar in PowerBI combined wih Transaction data. I have created a measure calculating LTM revenue: Revenue Netto LTM = CALCULATE([Revenue_Netto],DATESINPERIOD(Dates_Lookup[Date],MAX(Dates_Lookup[Date]),-12,MONTH)) The calculation is not very accurate though and I...

HI There I have a power pivot (also in powerquery) table ProcessData that includes 3 columns: UniqueItemRef; Status; Update (=datetimestamp) If an item has passed through several statuses it will have several rows for those statuses (same UniqueItemRef and Status on each row) Also, if...

Hello, pretty new to power query and dax, I've used < List.Sum list.firstN / Range and List.Accumulate to create running totals, and an index column in Dax power pivot but I'd like to create one based on a condition, so at simples two columns 'Product ' a b c and 'sales' and create a running...

Hi. I have created 3 matrix tables (below). The first sums the KS (this stands for school key stages) per day. The second table is the running 7 days sum of those daily totals. And the third table is that 7 day total/divided by denominator *100000 For some reason the third table doesn't do the...

Hi all, This forum has already helped me so much in the past months but now I have the first question I couldn't find an answer to anywhere else, really hope someone can point me into the right direction. I have an Excel model where I use a data model and power pivot. Basically user enter the...

Hi there, I have a FACT table which contains payment due amount and due date (due date is a link to a DIM_DATE dimension table). I have a requirement to add a new measure to the fact table, sums the total amount of 'passed due' payment due amounts (i.e. where for the current row, summarizes...

I have the following dax measure in the value area of a pivot table to return a concatenated list of unique values from a table: =CONCATENATEX( Values( Table1[Column2] ), Table1[Column2],", " ) There are instances where 0 is returned as the value because no corresponding values...

HI I'm using the SWITCH/TRUE function to create a Yes /No return on a column that is generating the number of months between to date. The issue is where between some on the date the number of months is 0 (zero) and some are blank. I can see from filtering the column there are 393 zero's that...

Hello all!! I'm trying to create a measure to calculate first time past rate for a location. So if I have a day where there is ten failures and one pass on a item, it would be a first time pass rate of zero%. So the First time pass rate should be 60%

So I have a Power BI screen that i created via Power BI desktop and the connection is to SharePoint Online List. I have on my screen 3 elements, a) date slicer to select the date range to b table, B) Table, dynamic filters the data based on A date slicer. C) a card visual to sum the total of...

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 calculate the Per Capita utilization of the 311 Non-Emergency Phone System in my home city for each of the 280 defined Neighborhoods in my home city. I have two Power Pivot tables in my data model: The first table consists of 311 Telephone Calls (similar to 911 calls, but...