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
0
votes
0 answers

How to create a measure that is a virtual table of the rows that are not contained in one table and contained in another

I need to create a measure with a logical DAX function that will iterate row by row between three tables and it will return me a virtual table of the rows that are in the first table and not in the other two. My goal is to create a Maintenance…
NLGenin
  • 45
  • 1
  • 5
0
votes
0 answers

How can I export all data from a table with millions of rows to csv from Power BI using Power Automate?

I already know how to do it using DAX Studio. However, I would like to do it automatically. As the Pbi file provided to me is using a direct query I am very limited to do some tasks. Thanks!
reis_fp
  • 1
0
votes
1 answer

Vertipaq Analyzer Metrix pane in Daxstudio

How do you close the Vertipaq Analyzer Metrix window in Daxstudio? I want to close it to see the Server Timings window. I do not know any other way than to close the whole Daxstudio. The Auto Hide option makes things worse. Once I use it I am not…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
0
votes
1 answer

PowerBI DAX question for groupby or other possible soution

I have a sample table like below Any same ID that have column M Name with A (starting as "Ann") and B then I want to have desired solution as A,B I then think about count any words "Ann" and B as 1, so when any same ID has column Calculation as 2…
RJAP
  • 49
  • 6
0
votes
1 answer

PowerBI - Counting the attributes of a record based on date

I have two simple tables. I need to able to determine who is 'new' as of a particular date (say January) and then count only those attributes. There's a 1:M relationship on name. I basically need to answer the following questions with the below…
Insan3
  • 37
  • 7
0
votes
1 answer

How to get same day prior month value using DAX formula?

In power BI we need Dax formula which return prior month same day value. Means when report run for 1 April to 8 April 2021, then measure return value of 8 March 2021 only. Can anyone please help me to derive this measures.
NP007
  • 659
  • 8
  • 21
0
votes
0 answers

ORDER BY in DAXSTUDIO without specifying column name

Is there a way in Daxstudio to sort table without specifying column name? This does not work: EVALUATE MyTable ORDER BY 1 I am looking for the equivalent of SQL: select * from MyTable order by 1
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
0
votes
1 answer

Can I add a filter to a SELECTCOLUMNS so that I can use two different table depending on the filter in DAX

I am using DAX Studio and I would like to add a filter to the table field in SELECTCOLUMNS so that it using two different table depending on the filter's expression result. In other words what I would like to do is similar to the following : DEFINE…
Abdelhamid Sajid
  • 1
  • 3
0
votes
1 answer

Sum with filters but without using filter keyword in DAX

I am trying to find sum with two filters on same column. We can use FILTER keyword, but it takes too much time. So I did following things, but nothing seems to be working. The second filter never gets applied. 1. MEASURE pop_hd_new[Connectivity %] =…
Rahul Kumar
  • 139
  • 3
  • 10
0
votes
1 answer

How to get the sum of the Calculated measures flag in PowerBI set to 1

I am facing an issue in PowerBI measure as stated below :- Below is my table with stated columns , times is the calculated measure I created Table name :School StudentID location attendancedays times Month a Tamilnadu 20 …
sameer
  • 3
  • 3
0
votes
1 answer

How to compare a column in a table from a column in another table in PowerBI

I am trying to create a calculated column that compares one column to another column in a different table, I want to compare the version of the applications installed in different computers so I can monitor if I am up to date or not. Here are how my…
Allen Andre Indefenzo
  • 311
  • 5
  • 19
0
votes
1 answer

SSAS DAX Grand Total not matching with actual Sum

I have a fact which has relationships with 2 dimension tables. Direct relationship Through Bridge table I have created a sum measure that should sum up the Amount column. I have created two queries that don't give me the expected result Query…
Sreepu
  • 123
  • 1
  • 1
  • 14
0
votes
1 answer

Calculate last lowest value using DAX

Data1: ID Value 2 114 3 108 4 107 5 113 6 112 7 106 8 109 Data Required In Power BI(DAX): ID Value last_recovery_id 2 114 5 3 108 4 4 107 X 5 113 6 6 112 7 7 106 X 8 109 …
Vlogs Bengali
  • 85
  • 1
  • 13
0
votes
1 answer

How to create DAX query with two date dimension table

I have two date dimension table called Date_Week and Date_Month, these tables have a relationship with the Fact table date field. I want to create a measure that rolls up the usage field from the fact for the last 7 days and the query which I…
sreeprasad k s
  • 53
  • 1
  • 1
  • 9
0
votes
0 answers

How to rank customers based on two columns of same table using dax expressions for ssas tabular cube

I have used below DAX Expression for getting top 10 customers based on one column of a table TOP10CUSTOMERS:= VAR SRANK = RANKX(ALL('TableName'[CustomerName]) ,[Columnvalue] , ,DESC …
harika dasa
  • 1
1 2 3
…
11 12