Questions tagged [dax]
Expression language used in Microsoft Power Pivot, Analysis Services, and Power BI for performing analytical calculations.
9,486
questions
0
votes
0
answers
9
views
Identify group level row in matrix visual using measure
I have a matrix in visual in PowerBI desktop in which I am trying to identify the group level row.
If my data contained car makes and drivers:
Car, Driver
Mercedes, Peter
Mercedes, Matt
Mercedes, ...
0
votes
0
answers
28
views
Power BI DAX Function
This is my data in Yardi :
Rank represents unique line no. for each GL code.
This is the matrix I created :
Now I want to calculate % which has logic mentioned below.
All the amount should be ...
0
votes
0
answers
7
views
Navigate from matrix to table and show the data based on select done from matrix
I have a matrix with column A and column B in rows, column C and column D in values. I have 2nd table contains data linked with column A.I am not able to figure out how can I show the data from table ...
0
votes
0
answers
8
views
Clear previous value selected PowerBI slicer on change from another slicer
I've 3 slicer in powerbi for referenceId, lower version, higher version.
On selecting reference id I see some versions value available in other two slicer. I've un linked the versions slicer from ...
0
votes
1
answer
17
views
Power BI: Ribbon Chart changed by Slicer
I’m new to Power BI.
I have a table like this:
Type
Food
Hygiene
NFI
City
1
2
1
City
3
1
1
Village
1
1
2
City
2
2
1
Village
1
3
1
City
3
3
2
I want to have a Ribbon chart with:
Ribbons (Legend)...
-2
votes
0
answers
11
views
Dynamic ABC analytics in Power BI [closed]
Can someone explain how does this DAX code work?
ABC Sales Amount =
VAR SalesByProduct =
CALCULATETABLE (
ADDCOLUMNS (
SUMMARIZE (Sheet1, 'Sheet1'[Артикул]),
"@ProdSales", [Sales Amount]
),
...
-2
votes
0
answers
12
views
Is there a visual calculation to get the value from the left column?
I have a matrix visual.
The row is Customer.
The column is FiscalYr.
The value is TotalSales.
I want to show the year over year difference. That is - current year sales minus previous year sales.
Is ...
0
votes
0
answers
12
views
On Histogram, show all months of the year but hide columns that a beyond the selected date
I'm trying to hide these columns.
I have edited the interaction of the chart so that a slicer with the date does not effect it to show all months for the year.
I can do it with calendar_date<=max(...
2
votes
1
answer
26
views
Show previous period and current period in the same line chart
I want to show the current period and previous period in the same line chart. The problem is that I need to be able to use slicers. For example
I am plotting an entire year, but if I want to select ...
0
votes
1
answer
17
views
Reshape table from long to wide using Power Query or DAX (not knowing number of columns to be added)
My question is similar to this post (How to pivot a table in excel from long to wide) except that I don't know how many columns to be add. In other words, one unique person can have more than one rows ...
0
votes
1
answer
24
views
Average PowerBI
I want to calculate an average of a column after modifying it with a multiplication.
This means that I want to calculate the average of:
CA N with discount = [CA N]-[Discount 1]-[Discount 2]
For your ...
0
votes
1
answer
14
views
Blank Values in Date table for a formula
I am trying to find the week ending for in the date table, however I realise the formula is giving me blanks on some of the months.
Week Ending on = CALCULATE(MIN([Date]),FILTER('Date',WEEKDAY([Date],...
0
votes
0
answers
13
views
Power BI DAX Calculate Moving Average While Ignoring Weekdays From Date Hierarchy
I am trying to create a moving average measure that gives me the moving average per month. My data has weekday as lowest level; however for this specific measure (and visual) I do not want the ...
1
vote
1
answer
26
views
Power BI calculate tiered commission, commission threshold changes over time
I have sales records, if the sales involves Party B, Party A has to split revenue with Party B for all sales >$10000. This split is set by the threshold below, and the boss is free to update the ...
1
vote
2
answers
43
views
In Power Query, how do I calculate difference between numerical values of two rows in a table?
A Power Query / BI newbie here. I have the following sample data table:
DateTime
Process
Activity
ElapsedProcessTime(s)
TimeInterval(s) (expected output)
17/Jul/2024 00:00:00
A
1
0
0
17/Jul/2024 00:...