dax

  1. G

    Creating Measures (or DAX?) in Power Pivot

    Hello, I'm looking for some guidance with if and how I could use measures to help me create some enhanced pivot tables. I have detailed a couple of specific questions in the document here (in red text in the Sheet: Pivot Test): s666-PQ-Impact system 2019.11.15a-ver4.xlsx But to summarise I'm...
  2. F

    PowerPivot, Running Totals, and Chart Lines with null data

    Good afternoon all, I'm certain that we've all had this issue at one point or another but I can't seem to find a solution--hoping that someone has something ready to go. Here's the summary: PivotChart with Date values on X AXIS and a Running Value Count 'flattens' when max is reached. The...
  3. S

    DAX Countrow Filter Userelationship not working together

    Does anyone know why the DAX below is not working? Do I have it in the wrong order? BTS Actual = CALCULATE(COUNTROWS('Schedule','Schedule'[Actual Count]), FILTER('Schedule','Schedule'[WO Type]="BTS") USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed])) Power BI just keeps...
  4. L

    How do i create this DAX table in Power Query

    I every one, i have a problem... I have created a table in dax, like this NISCountLT2 = SUMMARIZECOLUMNS(LT2[ID]; "Total"; COUNT(LT2[ID])) to count repeated IDs then i use this code to create a column with ranges for the report Bucket Range = SWITCH( TRUE(); NISCountLT2[Total]=1;"1"...
  5. S

    Return lowest date across two tables

    Hello- I am new to Power BI & DAX. I am struggling to work out how to return lowest date across two tables. I want the following rules applied If deceased date blank then end date If deceased date before end date- deceased date All else end date Format Looks like Below...
  6. J

    Extract unique value from column using DAX

    I've come across what I thought should be a simple problem, but I can't quite figure it out. I have a table that's the result of an expression that could have a column like this in certain instances: Row Key Index <tbody> AH4000 1 AH4000 2 AP9999 3 </tbody> What I want is to keep only...
  7. S

    Figuring out current QTR

    Hi, I thought I had this resolved. But starting in October it thinks November is the current QTR. This is my DAX columns I created in the Calendar table. These are the 3 columns i created =IF(MONTH([DATES])-1=0,12,(MONTH([DATES])-1)) = ROUNDUP ([SORT]/3,0) <today(),if(roundup(month(today())...
  8. M

    DAX for checking quantities

    I scrape the wonderful data at Brickset for showing basic DAX concepts, but I'm a bit stumped on a seemingly simple question someone posed. If I have Lego kits A, B, and C, can I create just a measure to tell if I have enough of the correct bricks to build kit D? I can use a helper column in...
  9. S

    Sort DAX measures random sort

    Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order. I've seen this before and moved them only to find them just thrown back into a random order. Any thought how to sort them again and avoid this. Thanks
  10. S

    #GETTING DATA, DAX issue

    Hi, all of a sudden 4 of my tables wont update. They say "#GETTING DATA". Only if i go into dax and manually refresh will they update. Or if I select the QRY inside excel and refresh the workbook connection. I've tried removing and readding it back to DAX. But still have the same issue? Thanks
  11. K

    DAX Measure to compare against prior update

    I need a DAX measure that compares latest version of financial data against prior version My data table has an'asof' column to tag which version the data originates from (100K+ rows) For example, I would like to compare the full yr 2019 cash number asof Sept 2019 vs. the full year 2019 cash...
  12. S

    Change the order of DAX tables

    Hi, I have 50 DAX tables. I would like to change the order of the tables. But every time I move the tables. They go back to the original order (order of when created). Is there not a way to set the order of the tables? Thanks
  13. S

    Dax need to calculate current QTD Sales

    Hi, I have a DAX formula for MTD I'm looking to total my sales YOY using QTD. So today is the 12 of September I need to see all sales QTD ending today and will compare them year over year. This is my MTD formula: =if(month(dCalendar[dateS])=month(today()) &&...
  14. S

    DAX last date Prior to a specific date

    Hi I'm trying to figure out what the last discount was on a Prior date. I have the following: tblInvPriceDisc that has a list of all the dates and discounts for all sku's tblInvSkuMaster that has a list of all sku's in the company ConfigurationTable that has the date i'm looking up. I would...
  15. S

    Dax Measure of LAST DISCOUNT Amount

    Hello all, I am in desperate need of some help with rolling back our inventory and seeing what the discount amount was on a prior date. I have a measure that rolls back the date and I have a table with the historical discounts by date. What I need to see is: SKU QTY DISCOUNT AMOUNT VALUE...
  16. S

    Refresh just one DAX measure based on a cell change

    Hello all, I'm looking for a way to refresh a DAX measure not the whole workbook. When I change a value in a cell. So if I change let's say the date in a cell I want a specific measure to be updated. Otherwise refreshing the whole workbook takes may staff 20 minutes. When I can go direct to...
  17. S

    Excel VBA to refresh just 1 DAX table

    Hi, I have a workbook with many pivot tables. I would like a VBA macro to run when the PIVOT TABLE changes. I have a dax table that is based on a excel table. When I change the value in the Excel table I would like to refresh just the one DAX table. So that my pivot table is updated. If I...
  18. S

    DAX measure produces more than TOP 15. Slicer issue?

    Hi, I'm having an issue with a DAX formula limited to TOP!%. But produces more that 15 lines. Could it be because I have a filter on the PIVOT TABLE for location. But need to add it to the measure? tblLocation.Loc# The measure below should provide me with the TOP 15 Brands sold for the day...
  19. M

    DAX Formula for Cumulative and %Cumulative

    Hi, I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense Total Items Delivered: TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile...
  20. M

    PowerBI: How to calculate/convert Time into Percentage using DAX/Measure

    Hi to all, I managed to get in Excel desired % of time difference from column E, easy job just changed the Data Type to Percentage. What are we calculating is % of these TimeDifferences, one per one (other columns inconsiderable). The calculation I used is: MOD(D3-D2;1) and Column F (%) is just...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top