Questions tagged [dax]

Data Analysis Expressions, or DAX, is the native formula and query language for Microsoft PowerPivot (an Excel Add-in) and SQL Server Analysis Services Tabular models.

Filter by
Sorted by
Tagged with
0 votes
1 answer
368 views

Calculate % of total during drill-down

I have a Power BI Matrix visual as shown below. At the moment it is showing the ISO Week Number. You can drill down to see the week ending date (not really a drill-down as it's the same level), then ...
Darren Bartrup-Cook's user avatar
0 votes
0 answers
27 views

How to check data by column, with date filter

How do I find in my table new values added in a column by date? I have a table, where I have a column with the contract numbers of my clients, but I want to make a comparison, if on my previous date I ...
Deforceh's user avatar
0 votes
1 answer
132 views

How to do VLOOKUP in my PowerBI table

Gentlemen, in my table I have a column CC (Number of Contracts), and another column "DATE" with the dates of each contract, but I want to make a comparison (Something like a PROCV in Excel),...
Deforceh's user avatar
0 votes
1 answer
1k views

Highlight MAX and MIN values in Power BI table visual using DAX

I have a table similar to the below in Power BI. DAX to create table: Sample Table = {("A", 2, 3), ("B", 3, 1), ("C", 8, 12), ("D", 4, 15), ("E", , 3)...
Darren Bartrup-Cook's user avatar
0 votes
0 answers
1k views

PowerBI - Need measures based on two separate tables to sum correctly in column total

I have a measure that calculates percentage changes between two separate tables. This measure is used as a rough way of predicting the next quarter's totals based on new weekly data at the time. I ...
angelofdev's user avatar
  • 1,156
0 votes
1 answer
23 views

Incrementing values when values changes in different column in excel

i want to change values when id values changes to different in excel like this ID ChangedId 8 1 8 1 8 1 22 2 22 2 25 3 Any help will be thankfull.
shubham yadav's user avatar
0 votes
1 answer
1k views

List.Sum in Power Query is not ignoring null values

I added a column with this code: = Table.AddColumn(#"Changed Type", "Total Quantity", each List.Sum( {[species_males]+[#"species_females-mixed"] })) List.Sum is ...
Susie Derkins's user avatar
1 vote
1 answer
2k views

How to add a measure to Excel PowerQuery which computes the cumulative value?

I have the following question regarding Power Query. For the correct setup, please enable Power Pivot (in COM Add-ins in Excel): Let us first consider the following example: I have inserted the text ...
Snowflake's user avatar
  • 181
0 votes
1 answer
348 views

Power BI formulas not calculating properly

I have a visual that I want to calculate as a percentage above or below a target goal. Let's say I have a table head(5) that looks something like this: id Date Inbound Requests Outbound Responses 1 ...
G H's user avatar
  • 5
1 vote
1 answer
3k views

Power Pivot DAX dynamic Percent of Column

I just started using Power Pivot and Dax. Today I learned the benefits of creating my own measures (counta, etc) vs creating them directly in the pivot table. So I thought I could do the same thing ...
daniellopez46's user avatar
1 vote
1 answer
3k views

Sum of previous year Power BI

I'm working in Power BI with data in the following format: Year Number Week Number Sales Value 1 1 20 1 1 15 2 5 32 ...ect ...ect ...ect I'm currently using the measure Total Sales = SUM(Table[...
TheGreatO96's user avatar
0 votes
1 answer
3k views

Referencing a Cell in DAX Formula Excel

I have imported a large data set into the data model in Excel and am working on a pivot table from it. I want to create a measure that can reference a cell in the worksheet. Currently I have =SUM(...
Concerned_Citizen's user avatar
1 vote
2 answers
701 views

In powerBI, using a measure breaks the relationship between two tables. What am I doing wrong?

I am doing membership statistics for an organization. In our membership_subscriber table, we have the the dates when the membership begins and ends. There are multi year memberships. I need to show ...
Ben Cor's user avatar
  • 11
0 votes
1 answer
67 views

How to make a DAX measure NOT to re-calculate on aggregated levels?

I have a DAX measure which works perfectly on the level 0 POV in the Pivot Table but I was wondering if there is a way to make it aggregate like a regular number when filtering to top level POV (e.g. ...
Arthur's user avatar
  • 169
0 votes
0 answers
488 views

PowerPivot get the last value recorded for a date

I have a PowerPivot query where I have 3 columns: ID, Date and a Value. Every day is possibly recorded multiple values each on new row. so it looks like: ID Date Value 1 1/1/2019 654594 ...
s3icc0's user avatar
  • 1
3 votes
2 answers
1k views

How to remove extremely annoying Power Bi popup?

Since an update, I regularly get a really anoying popup in the DAX editor in powerBI whenever I press ctrl-enter. Does anyone know how to turn this 'feature' off? This is the popup: It is ...
Jelle Hoekstra's user avatar
0 votes
1 answer
37 views

IF (VLOOKUP greater then number) then fetch value from same row in another sheet

After reading multiple posts on this forum and others without having any success or finding similar problems I've decided to try my luck with my own post. I will try to explain the problem to the best ...
Mattias's user avatar
1 vote
1 answer
3k views

Excel PivotTable Remove Column Labels

How do I remove the column labels so that I can create a PivotTable like the second example screenshot? | title | group | tagKey | tagValue | | example1 | groupA | firstTag | foo | | ...
A. Gardner's user avatar
1 vote
1 answer
1k views

How do I add a starting balance to a running total using DAX?

I need to add a starting balance to a working, running total. The measure that works was built using the Running Total Quick Measure from PBI: > tran_amnt running total in Date = CALCULATE ( >...
dav's user avatar
  • 10.3k
1 vote
0 answers
375 views

NVDIMM DAX boot

I'm trying to find more definitive information, but are there documented examples of an OS booting from real NVDIMM (single or multiple), possibly with a DAX filesystem? I understand that NVDIMM's ...
Asteroza's user avatar
1 vote
0 answers
242 views

DAX RANKX formula to skip ties properly

I have (video) games collection table [GC], with 'title, 'series' and various score columns (aggregate, experts, users...). The table in PowerPivot view: I can't figure out a formula that properly ...
Radian's user avatar
  • 13
0 votes
1 answer
216 views

Combine data from two seperate tables in Power Pivot without using a join based on concatenated key

I have two separate data sources with effectively the same columns Date Vendor Campaign Ad group Keyword Impressions Spend What I am trying to do is stitch the data together in a fact table in order ...
Chris's user avatar
  • 333
1 vote
0 answers
124 views

How to compare one row to others in DAX in Excel

I have this table which has foreign keys from several other keys: Basically, this table shows which students registered in which module run by which teacher in what term. I want to query the ...
Jahongir Rahmonov's user avatar
0 votes
1 answer
56 views

Getting #NUM! for outer nests of IF statement division

I have some sales figures for which I have values in pounds, units, and dollars. From PowerPivot, I'm creating a pivot with Periods columns (Current Week, MTD, QTD, YTD) and sub-columns of "Measure" (...
Frameworker247's user avatar
12 votes
4 answers
85k views

Excel 2010 PowerPivot: How do I show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option: However, using ...
Andi Mohr's user avatar
  • 4,225