# 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.

25
questions

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 ...

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 ...

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),...

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)...

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 ...

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.

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 ...

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 ...

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
...

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 ...

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[...

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(...

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 ...

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. ...

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
...

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 ...

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 ...

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 |
| ...

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 (
>...

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 ...

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 ...

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 ...

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 ...

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" (...

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 ...