dax

1. Running total with two pertinent Date columns

Hello all, I believe I need DAX measure and I'm not finding what I need on the google machine. It's also possible I found what I need but did not comprehend it. First of all, I'm using Excel (PQ & PPivot). I have two tables. Here's the first: Note each employee can have multiple positions...
2. DAX calculated column for any location <0

Hi, I need help on creating a calculated column and or measure for any location where the OH is less than 0. I have a table with OH and location in the next column. But I need to list any models where and location has a qty OH less than zero. I want to see all locations OH so I can see if...
3. 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...
4. 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...
5. 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...
6. 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"...
7. 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...
8. 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...
9. 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())...
10. 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...
11. 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
12. #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
13. 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...
14. 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
15. 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()) &&...
16. 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...
17. 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...
18. 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...
19. 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...
20. 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...

This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...