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...
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.
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]),
USERELATIONSHIP('Calendar'[Date],'Schedule'[Actual date performed]))
Power BI just keeps...
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();
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...
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
What I want is to keep only...
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
= ROUNDUP ([SORT]/3,0)
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...
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.
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?
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...
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?
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:
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.
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...
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...
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.
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?
The measure below should provide me with the TOP 15 Brands sold for the day...
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...
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...