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
0answers
17 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
0answers
21 views

Find the last balance quantity per customer per month (Power Pivot)

I have the below dataset (Table 1), and I would like to create a new calculated column to only have the last Balance Qty per month for each customer. The last column (EOM Balance Qty) illustrate ...
0
votes
0answers
5 views

Power Pivot Measures

My Office version is 2013, everything fine except with measures that were in cells not showing output computations, but only text of name of measurement. Anyway to get pass this issue by any chance, ...
0
votes
1answer
37 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
0answers
24 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 ...
2
votes
2answers
466 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
1answer
27 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
1answer
484 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
1answer
439 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
0answers
319 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
0answers
224 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...). table in PowerPivot view I can't figure out formula that properly skips ...
0
votes
1answer
67 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
0answers
114 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
1answer
50 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
4answers
80k 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 ...