dax

  1. iosiflupis

    DAX Measure formatting to have thousands separator (comma) in visual

    Hello all, I have the following DAX Measure: Total Deplaned Cargo = VAR TotalDeplaned = SUM(Cargo_Numbers[Ameriflight Deplaned]) + SUM('Cargo_Numbers'[American Deplaned]) + SUM('Cargo_Numbers'[Southwest Deplaned]) + SUM('Cargo_Numbers'[United Deplaned]) RETURN...
  2. M

    Small changes needed, DAX (Power-BI) code does not work

    Can someone figure out what is wrong with my code? Purpose of the code: If the column Brand is filtered and SKU is not --> value sales of 2022 of the whole brand with all SKUs If the column SKU is filtered --> value sales of 2022 of a specific SKU If no filters --> value sales of 2022 of all...
  3. D

    DAX refer to column of a virtual table

    Hi, I i have the following EVALUATE VAR NB = CALCULATETABLE ( Table2, FILTER ( ALL ( Table2 ), Table2[Column2] <> "B" ) ) RETURN NB is there a way to refer to 'column2' of the table NB, not the original so something like EVALUATE VAR NB = CALCULATETABLE ( Table2, FILTER ( ALL...
  4. E

    Convert Excel Formula to DAX Which Averages Last 2 Values Until Certain Period of Time

    I have the following table in Excel: DATE VALUE 1/1/2024 100.00 2/1/2024 150.00 3/1/2024 200.00 4/1/2024 5/1/2024 6/1/2024 7/1/2024 8/1/2024 9/1/2024 10/1/2024 11/1/2024 12/1/2024 Lets say this table is called Table1. For the Months 4/1/2024 - 12/1/2024...
  5. M

    Calculating Same Day Last Week only works partially in Power BI

    I have this DAX that is supposed to return appointments for the same day last week by each brand for each date. It is working absolutely fine and giving me the desired results as I intended. The only issue is that for some brands, where there are 0 appointments for the current date, it shows 0...
  6. M

    Power Pivot Measure If Statement giving incorrect value

    Hi all, I have a measure if statement to calculate the AAFR based on the different companies for YTD. When I set the filter to 'Maine Group' it calculates the correct value, when I select 'Smyth Steel' it calculates the correct value however if I don't filter the data I get a value approx. 10x...
  7. M

    Count the Number of Sick Occasions in Dax - Calculated Column - PowerBI

    Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...
  8. M

    find the sum total of measure values

    Hi all, I have 5 KPIs created in measures that I want to get a total value for, I've google it all and the best option i can find is : =[Accident KPI Score] + [Site Inspection KPI Score] + [Site Returns KPI Score] + [Operational RA KPI Score] + [NC Target Date Met KPI Score] however this...
  9. P

    PowePivot - Create a slicer of a measure or calculate values from one table using filter from another table

    Hello, I've been struggling quiet a lot with this issue and been looking high and low but I'm not able to find any answer. Hopefully some master can help me solve this issue! I have two table, lets call them Table1 and Table 2 in Power Pivot. They have relation to each other through Column...
  10. D

    Power BI daily average calculation

    I am creating a dashboard to display some calculated metrics. I have a detail with thousands of lines of submitted invoices. I have pulled out the Creation Dates, User, and the number of invoices submitted (by day and user), and I am trying to do some user level comparisons. I have been able to...
  11. M

    Power BI DAX Rollover Function In Matrix Needs to Factor for Negatives

    I have an Inventory Walk table that has month on columns and values on rows. Rows consist of Stock on Hand, Total Receipts, Total Demand, and Net Inventory. Stock On Hand is always the current month, then Total Receipts and Total Demand for each month. Net Inventory is a measure that is Stock...
  12. I

    PowerBI Matrix creation

    Hey guys, I Need to create a PowerBI Matrix visualization, which should present number of issues that contain column AND row count value. I'll explain: In the following snapshot, you can see how my DB looks like (on left side): 'issue_id' and 'tags' (which present the issue tags) fields. each...
  13. D

    DAX Filter by values found in a column of another table

    I hope this illustrates what I would like to do i fist have a virtual table filtered for just green products, and then a second for just red , I would like to filter the second table to show only customers or whatever that are contained in the first; EVALUATE VAR ttable = CALCULATETABLE (...
  14. TheMacroNoob

    Closest Available Datapoint in a SUMMARIZE Table

    Hello Power BI experts. I have a dashboard tracking hours on various days, among other data points. I am using a SUMMARIZE table function, grouped by the columns you can see in the code below. The only problem I have is that the ClinicHours table does not have any data prior to 1/1/2023. I have...
  15. S

    Excel DAX question on Quarter to date sales.

    Hi, I've created a dCalendar in Excel with all the dates for several years. I can pull the slicer and use it in my pivot tables. I can select the date, month, year... But for the QTR our year starts Feb 1. So I need QTR to date sales. That would be 4th QTR today all sales from Nov 1 to today...
  16. D

    DAX ; how MIN / MAX see data model

    Hi, this is more a a theory question than practical; in the measure ; Tbetween:=CALCULATE([TotalUnits], FILTER(ALL(Table1[Units]), Table1[Units] <= MAX(Table3[Max]) && Table1[Units] >=...
  17. TheMacroNoob

    SUMX and Subtotals Not Adding Up

    Hello experts, In my Power BI report I am trying to do a calculation on all rows in a table, then be able to correctly add them up in the subtotal lines by whatever grouping I am using. In my case, the final grouping I have in Matrix rows is 'Calendar'[EOM], which is not being used in the...
  18. M

    DAX-Median of 4 measures and Median of 4 column

    1-I want to to get Median,Average or Stdv of 4 measures 2-I have 4 columns,Clm1,Clm2,Clm3 and Clm4 I want to create calculated column to get the Median or average of each row of those 4 columns. But the answer should be for DAX, no need power query or excel formulas.
  19. A

    Count Number of Repeat Customers

    Hello all - Having some trouble wrapping my head around this. I would like to count the number of repeat customers in my Orders table. The customer email is the unique value to count. I want to be able to use this calculation to create a table such as the one represented below: The...
  20. D

    DAX Addcolumns

    Can someone help with addcolumns, I have SUMMARIZE; EVALUATE SUMMARIZE ( Table1, Table1[Date], Table1[Item], "JA", CALCULATE ( SUM ( Table1[Units] ), ALL ( Table1 ) ), "RA", SUM ( Table1[Units] ) ) but want to use ADDCOLUMNS, so, EVALUATE ADDCOLUMNS ( VALUES (...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top