Stack Overflow
Stack Overflow

Questions tagged [daxstudio]

DAX Studio is a free open-source software to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing and query execution breakdowns.

DAX Studio is a free open-source software to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an Object Browser, query editing and execution, formula and measure editing, syntax highlighting and formatting, integrated tracing and query execution breakdowns.

169 questions
4
votes
4 answers

DAX lookup first non blank value in unrelated table

How to lookup the first non blank value in unrelated table. I want an equivalent of: SQL outer apply (select top 1 ...) or Excel VLOOKUP. The DAX LOOKUPVALUE function as used in that code does not work. LOOKUPVALUE( SearchTable[name] ,…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
3
votes
2 answers

Replace BLANKS with 0 using DAX in PowerBI

I have written the following DAX Query Global Spends = CALCULATE(SUM(PSL[Total Spend]),FILTER(PSL,PSL[PSL Flag] = "Global")) In some combinations of Global Lead and Class the Global Spends value is BLANK which means that there is no PSL Flag as…
coder_bg
  • 340
  • 6
  • 20
2
votes
0 answers

How to calculate Count of a Filtered Employees based upon a Measure in Power BI DAX

I have a dataset of employees working on month-to-month basis, The dataset looks something like this, I have a Slicer for Date Range from which the user can select any date range and data will be filtered accordingly. I have a Matrix Visual that…
Asad Hussain
  • 564
  • 2
  • 15
2
votes
3 answers

Accumulate values over years in DAX

My table has a column that calculates the cumulative total year-to-date (YTD). The column is Balance BRL. It works ok using the DAX function DATESYTD. The column Balance BRL is perfectly achieved using the DAX below: Balance BRL = CALCULATE ( …
Arnold Souza
  • 601
  • 5
  • 16
2
votes
0 answers

Difference between SUMX and Calculate in DAX Language for this specific example

I have the following two DAX Commands, who seem to be giving different results, First DAX command FourLeggedSales = SUMX( FILTER(Purchase, RELATED('Product'[Legs]) = 4), Purchase[Quantity] ) Second DAX Command, FourLeggedSales =…
Asad Hussain
  • 564
  • 2
  • 15
2
votes
1 answer

List of all queries of Power BI

Is there a way to get the list of all SQL queries in the first step of all Power Query. Please note, I am NOT interested in the source paths (server/database) which can be accessed through Option/Sources settings.
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
2
votes
1 answer

PowerBI DAX Comparing two measures

I am having an issue and cannot figure it out, since I am still pretty new on DAX. Currently, I am having a table in the database, where it stores the "Extracted" documents that have been automatically extracted value by the software. I also have…
Matas
  • 21
  • 2
2
votes
1 answer

Group Items in Comma Separated values in Dax

I have following DAX code. I need comma separated holiday list based on Week No . I tired with CONCATENATEX function and it combine all comma separated holiday list in each row instead of week wise. Any one have any idea how we can achieve below…
NP007
  • 659
  • 8
  • 21
2
votes
2 answers

Update a Percent Measure with Multiple Slicer Selections

I have a table where I want to update the values of "Percent Values" Measure at each filter (a user can select either one, or multiple values from a slicer/s). In visualization all the markers for a Year, Month need to add to 1.0 With or Without…
WannabeSmith
  • 435
  • 4
  • 18
2
votes
1 answer

How to get table rowcount in DAX Studio

I'm trying to compare the column count of two tables, one in SSMS and one in DAX Studio, but I've never worked with DAX or Dax Studio before. In SSMS, I ran SELECT COUNT(*) FROM MyTable to see the rowcount. In DAX Studio, I ran COUNTROWS(MyTable)…
half of a glazier
  • 1,864
  • 2
  • 15
  • 45
2
votes
1 answer

Dax formula - calculate 6 rolling month back average

I have a table named [Tasks] which is linked to a date table named [Dimdate]. They are linked with the date of reference of a tasks [DC_date]. The objective is to have a measure that can calculate the average on in interval of 6 month before the…
Sara ATINE
  • 23
  • 2
2
votes
1 answer

Using DAX Studio to export Tables from Power BI for date formatting for Excel output

I have an expression right now that exports the table while removing unnecessary columns: EVALUATE ALLEXCEPT(TABLE, TABLE[M],TABLE[N]) In the table there are columns that have dates that when brought into CSV end up like: Is there a way to add a…
konsama
  • 327
  • 2
  • 12
1
vote
1 answer

DAX : How to count the number of specific categorie based on an date column and ID column

I meet some issue when creating a measure on dax My dataset contains data on call center , like this : The field STAT is "0" for call without answer and "1" for call with answer(picking up) I want to count the number of "0" based on DATE column…
Arthur_75
  • 35
  • 2
1
vote
1 answer

Want to show null values in Dax

I have this sentence in DAX: DEFINE MEASURE 'BUYING SHOP'[FromDate] = CALCULATETABLE ( DATEADD ( 'BUYING SHOP'[FROM_DATE], -1, YEAR ), KEEPFILTERS ( TREATAS ( { @sadCode }, 'BUYING SHOP'[SAD_CODE] ) ) ) MEASURE 'BUYING…
Adrian Salas Agüero
  • 13
  • 2
1
vote
1 answer

Dax Studio - The syntax for Calculate is incorrect

I am learning to use DAX Studio to test out my DAX scripts, DAX Studio says my script is wrong, but I am not sure what exactly is the problem CummulativeWeek = CALCULATE ( SUM ( Data[Value] ), FILTER ( ALL ( Data[Week] ), Data[Week] <= MAX (…
user2552108
  • 1,107
  • 3
  • 15
  • 30
1
2 3
…
11 12