Most voted "dax" questions
DAX is a collection of functions, operators, and constants that can be used in a formula or expression to compute and return one or more values. To put it more simply, DAX helps you create new data information that is already in your model.
Learn more…13 questions
Sort by count of
-
2
votes1
answer70
viewsDAX Filter Context - Powerbi
I have a simple spreadsheet for fuel supply control 3 columns: Date of filling KM Car Plate on odometer at the time of filling. I want to set up a measurement to know how much was driven in KM For…
-
1
votes0
answers47
viewsCumulative Total 12, 6 and 3 months
I need to enter below my total, a cumulative total of 12,6 and 3 months. The base I use contains a column called competency to group. I actually created another table to put these 3 rows of…
-
1
votes2
answers478
viewsFormula to Count Boolean Values Power BI
Good evening, everyone, I am trying to make a Count with boolean values in power bi, using DAX formulas, but formulas do not return any value in the graphs. Does anyone know how to tell the problem…
-
1
votes1
answer58
viewsLowest value (DAX variables)
I need to create a measure (MAX) that calculates the smallest among several variables, also what we have in Excel called "SMALLER"... My attempt is as follows ("Unsuccessful") M_Teste = var v1 = 10…
-
0
votes1
answer1209
viewsDifference between multiple dates in the same column
I have the following problem.. I have the following table: I want to create a calculated column that tells me the difference of days between two dates of the same code (COD), the difference shall be…
-
0
votes1
answer148
viewsDo Not Show Blank Value with DAX
Good morning guys, I’m trying to create a function on DAX that instead of showing the value Blank on my Dashboard, show the value 0. But my power bi are returning me the following error: **` The…
-
0
votes0
answers48
viewsI need to calculate the date difference in the same column - DAX PBI
I need to know how many days it takes a customer to make a new purchase, IE, what is the difference between purchase dates. I used the logic cited here as a possible solution, but without success:…
-
0
votes0
answers9
viewsConditional column construction with date comparison
I need to create a date column with a condition for comparing existing dates in the "Start Date" column for the same type of equipment. That is, for equipment 1, I need to return in the first row of…
-
0
votes0
answers8
viewsDAX - Searching for keywords in sentences using DAX language in Power BI
I have a problem regarding DAX in Power BI. I need to categorize the locations according to sentences. I have mapped the keywords as image attached, but do not know how to search for them in the…
-
0
votes1
answer162
viewsFormat Switch in Power BI (DAX)
good night! I’m new to DAX and I’d like a hand with the following question: Meta Formatada = SWITCH (KPI.Formatacao , "Money", FORMAT([Meta],"Currency") , "Numeric", FORMAT([Meta],"General Number")…
-
0
votes0
answers7
viewsChange the start and end date reference of a month in Power BI
I need to create filters in Power BI Dashboard in which the month of August, for example, starts on the 20th of July (previous month) and ends on the 19th of August. This should be done for all…
-
-1
votes3
answers433
viewsCalculation with date filter and Ids, Power BI
Good morning, I need to create a measure that makes the following calculation: (Line value)/(Initial value) However the calculation should be done respecting the ID (not divided by values of other…
-
-1
votes1
answer240
viewsFour/While condition in M language - Paging API in Power BI
Hello, I need help implementing a four/while loop in my api. Created this paged API below, works correctly, but in the OFFSET property, I need to stipulate the next number of the sequence, when the…