Super User
Super User

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.

Data Analysis Expressions, or DAX, is the native formula and query language for Microsoft PowerPivot and SQL Server Analysis Services Tabular models. DAX includes some of the functions that are used in Excel formulas, and additional functions that are designed to work with relational data and perform dynamic aggregation.

25 questions
12
votes
4 answers

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 the PowerPivot add-in for Excel 2010 this option…
Andi Mohr
  • 4,315
3
votes
2 answers

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 particularly annoying considering it can't be closed or…
Jelle Hoekstra
  • 141
2
votes
1 answer

Why WEEKNUM returns a different week of the year depending on the selected date of the week?

According to Microsoft, the Excel function WEEKNUM is used to return the week number for the specified date based on a specific model (1 or 2). The week number indicates where the week falls numerically within a year. Model 2 means that the week…
Dario de Judicibus
  • 121
1
vote
1 answer

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 below, so one could try it in Excel…
Snowflake
  • 211
1
vote
1 answer

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 with percent to column total. I know I can easily…
daniellopez46
  • 257
1
vote
1 answer

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[Sales Value]) and slicers for Year…
TheGreatO96
  • 15
  • 1
  • 4
1
vote
1 answer

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(Column 1) * 83 (from cell A3) I don't want to hard…
Concerned_Citizen
  • 603
1
vote
2 answers

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 the statistics for a specific year. I know that I…
Ben Cor
  • 11
1
vote
1 answer

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 | | example1 | groupA | secondTag | bar | | example2…
A. Gardner
  • 111
  • 1
  • 4
1
vote
1 answer

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 ( > SUM ( 'History_Pivot'[tran_amnt] ), > FILTER…
dav
  • 10,618
1
vote
0 answers

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 are pretty small right now (NVDIMM-N currently at…
Asteroza
  • 11
1
vote
0 answers

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 skips ties, if there are rows with the same…
Radian
  • 13
1
vote
0 answers

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 following: How many students have registered for more…
Jahongir Rahmonov
  • 111
0
votes
1 answer

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" (Dollars, Pounds, Units). The calculation I'm…
Frameworker247
  • 183
0
votes
1 answer

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 the monthly figure, quarterly figure and finally…
Darren Bartrup-Cook
  • 515
1
2