All Questions
Tagged with power-query dax
4
questions
0
votes
1
answer
2k
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
3k
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 ...
1
vote
2
answers
822
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
77
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. ...