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
1
vote
1 answer

DAX Flag in Matrix Visual - Multiple levels of analysis

I replicated an issue I am having with the 'Adventure Works DW 2020' pbix file, so if my analysis seems a little out of context, please understand this example is not the true data I am working with. The pbix I used can be downloaded…
Clifford Piehl
  • 483
  • 1
  • 4
  • 11
1
vote
1 answer

DAX - Frequency of Selected Values as a calculated Column

I have a simple table here: I need to make a measure that counts records grouped by the Number column. Ideally: I also need this measure to by dynamic for whatever records are selected. So if a subset of the table is being used: (Same example…
Clifford Piehl
  • 483
  • 1
  • 4
  • 11
1
vote
1 answer

Need help converting date functions from SQL Server to DAX

I am trying to convert the following date function from t-sql to dax. My goal is to get the adjusted_date column I got from SQL into PowerBi. select EOMONTH(DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, [date]) +1, 0)), 1) ; So far I have DATEDIFF…
AOE_player
  • 536
  • 2
  • 11
1
vote
2 answers

Concatenate Tabular Analysis Service

Suppose I have a data model with SSAS-Tabular Analysis Service. In this data-model I have multiple tables but for ease suppose I have "Table1", "Table2" and "Table3". Each of these tables have a column named "Source.Name" which indeed indicates each…
BloomShell
  • 833
  • 1
  • 5
  • 20
1
vote
1 answer

Use value from SUMMARIZECOLUMNS as filter in CALCULATE

I'm trying to use SUMMARIZECOLUMNS instead of SUMMARIZE as recommenced by this article: https://www.sqlbi.com/articles/introducing-summarizecolumns/ As shown by the DAX query below I'm trying to create a summarized table of customers and their…
StephRas
  • 33
  • 5
1
vote
1 answer

DaxStudio - Implementing data lineage with table variables

I have 2 problems : When running the code below with DaxStudio, I get an error along the lines of "TREATAS function expects a complete column reference" ; How can I implement data lineage with table variables not coming from a table of a data…
Frederi ROSE
  • 297
  • 2
  • 9
1
vote
1 answer

How to join three tables with relationship using DAX only

I need a help here. I have 3 datasets in power BI having relationships. Now, I have to use these power BI datasets in Power BI Report Builder. I need to join these three tables using DAX only in Power BI Report Builder. I am trying the below code…
sam
  • 1,242
  • 3
  • 12
  • 31
1
vote
1 answer

Running MAX of values in another column in DAX

I'm working on having a column whose values are the running MAX of another column. My main table has three columns and I use the summarize function to virtually add another column named as SUM OF EACH DATETIME to the summarized table. Now I want to…
Parham.Trader
  • 47
  • 1
  • 4
1
vote
2 answers

applying a measure filter with date using DAX query

I am trying to get the customers whose Amount(Measure) is greater than 1000 for the given date period. But the results I get are less than 1000 even. Does the filter query in DAX doesn't work for Measure with a date? The DAX query…
priya
  • 438
  • 3
  • 10
1
vote
1 answer

DAX - Rankx by multiple Categories Issue

I have 4 Categories (GP, ID, Age, Date). I would would like to create calculated column and group by GP, ID, and Age and Rank/ count by Date to see how many months each member has in past 24 month. My Code works until I have members who cancelled…
SamR
  • 517
  • 3
  • 10
  • 24
1
vote
1 answer

How to use the result of a measure in the filter of a DAX query?

I have a measure in my power bi dataset called Nett Wipp. I need to write a query that gets some data from my dataset and filters where Nett Wip is not 0. In plain English my query should be: get me Invoice Recov % where Nett Wip is not 0 (Invoice…
Hedgybeats
  • 297
  • 1
  • 4
  • 16
1
vote
1 answer

DAX Iterator Behavior

I don't think this is doing what I want it to do. I have a fact table with columns date, weekstarting, customer, product and qtyshipped and I want an average product sales including dates with 0 sales. The 0 sales dates don't exist in the table. If…
getunstuck
  • 11
  • 1
1
vote
1 answer

Updating the values of variables in DAX

I need to change the value of variables in a switch in dax: switch( true(), condition1, var test1 = 2 var test2 = 3 ,condition 2, var test1 = 4 var test2 = 5 , var test1 = 7 var test2 = 6 ) I need…
AndreA
  • 779
  • 9
  • 22
1
vote
1 answer

Determine if 2 date columns are <= today and <= end of the next month in Power BI / DAX measure with IF statement

I have 2 columns that includes 2 different dates. What i'm trying to do is to create a calculated column that determines whether column "governance" is <= TODAY and the "contract issue" column is between the start and end of the next month( only…
Mido
  • 11
  • 1
  • 4
1
vote
1 answer

running sum/cumulative sum in direct query power bi

i have spent alot time on this with this, but not sure why this aint working.i have the dataset like: part loc wk demand cumulative 123-1 1000 20_wk01 10 10 123-1 1000 20_wk02 15 25 123-1 1000 20_wk03 12 …
ramesh reddy
  • 13
  • 3
1
2
3
…
11 12