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.
12
questions with no upvoted or accepted answers
1
vote
2
answers
751
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 ...
- 11
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 (
>...
- 10.3k
1
vote
0
answers
377
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 ...
- 11
1
vote
0
answers
247
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 ...
- 13
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
438
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 ...
- 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 ...
- 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.
0
votes
1
answer
70
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. ...
- 169
0
votes
0
answers
508
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
...
- 1
0
votes
1
answer
44
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