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

a DAX formula that can give my averages for similar past events?

I have Athletic Performance data in a dashboard, one aspect of the data is a chart which shows the team average practice load through the week (how much athletes did at practice). Is there a way I can write a dax formula to show an average from each…
Jonathan Sedy
  • 1
  • 4
0
votes
0 answers

how to filter table on the bases of Measure

I want when user to click on the matrix cell then filter all the records. show all the records of this cell to another table How can I pass a measure dynamically in the following code? table = filter(tablename, condition=[measure]) I want the…
Muhammad Raun
  • 1
0
votes
0 answers

Applied filters in dax is not working when we supplies multiple values

here for each quoteId I have multiple quotes panels. if I match mandatory panels to quote panels - (using Power query - left join) - if the mandatory panels don't match, i will get nulls for a few panels here the problem is - when I supply multiple…
usmansharif shaik
  • 65
  • 8
0
votes
1 answer

Calculate median of sum of interactions for selected date range and selected value

I am trying to plot a histogram to show the distribution of incidents based on the sum of interactions within a selected date range and region center, as filtered by the user. To do this, I have three datasets: incident_interactions, calendar_table,…
Rahul
  • 467
  • 1
  • 8
  • 24
0
votes
0 answers

Countif alternatives on Power BI ("ALL" Functions -> Memory allocation)

I did what i wanted with excel by using Countif I have Channel_Session_ID column, i want to count it without any filter and get only when count=1. The problem is when i do it with ALL-ALLEXCEPT functions, i get memory allocation so i guess those…
cankut
  • 19
  • 7
0
votes
1 answer

Count distinct string values per key DAX

Say I have this data structure Order Number Product Type 123 A 123 B 123 C 123 C 234 A 557 B 557 C I would like to group by distinct values of product type per key so I get the following Order Number Product Type Distinct…
Alon_T
  • 1,430
  • 4
  • 26
  • 47
0
votes
1 answer

Dax formula to find the last CHILD ID from PARENT ID in same table

How can I get the last Child Id from Patent ID in Power BI Project ID Project Original ID 1234 123 123
Rafi Ur Rehman
  • 11
  • 2
0
votes
0 answers

Dax Query- To Calculate MAXID and Sum of Amount

I have below sample data: IncidentID TransactionID Recordeddate Name Amount 10 1 13/01/2023 Recovery 1000 10 2 13/01/2023 Reserve 2000 10 3 13/01/2023 Reserve 3000 10…
Ankur maheshwari
  • 1
0
votes
1 answer

What is the difference in TMSCHEMA vs MDSCHEMA in DMV of Power BI models

For example, what is the difference between in those 2 when querying DMV? select * from $SYSTEM.MDSCHEMA_MEASURES select * from $SYSTEM.TMSCHEMA_MEASURES When those queries are going to return different results?
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
0
votes
1 answer

Extract measure alias assigned in a visual

Is there an external tool for Power BI which allows automatically to extract column or measure alias name which as been assigned in a visual. Is it stored anywhere in DMV?
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
0
votes
0 answers

Paginated Reports, Date Range parameter giving Text/Date format type error

I've created a Startdate and EndDate parameter for my paginated report that I'm referencing in my query. Both Startdate and EndDate have been set up as below using DateTime, both available and default values are set to None. StartDate and…
Jme1calff
  • 1
  • 1
0
votes
0 answers

PowerBI Desktop - Historical record of Status Category

I have a simplified PowerBI data model here: https://drive.google.com/file/d/13aXUR8mw2MdP3tw9K9LHxhqRCZqPaLwz/view?usp=share_link I want to make a timeseries visual that accounts for when a user's status category changes over time. This is what the…
Clifford Piehl
  • 483
  • 1
  • 4
  • 11
0
votes
1 answer

How to do left outer join of two tables without any relationship in DAX using naturalLeftJoin or Generate all functions

I have 2 sample tables, Table "EX4" and "Dates". Now I want to create a third table in DAX which joins dates with EX4 table. Now I want to join EX4 table with Dates[Sale_Date] where Dates[Sale_Date] >= Ex4_Ext[min_date] and Dates[Sale_Date] <=…
sam
  • 1,242
  • 3
  • 12
  • 31
0
votes
0 answers

MDX Query Subtotal

I am trying to get a subtotal in MDX on a separate column. Example below: This is what I current have: Table This is what I am looking for: Looking for this If someone could please help me? Currently this is the code I am using: (I ALSO HAVE A SALES…
Code Learn
  • 1
0
votes
1 answer

PowerBI: Create a new table using two columns from two different tables

I'm struggling a little but with this one. What I'm trying to is to create a new table using two columns of ID's from two different tables which I can then compare for duplicate values, highlight them and show those that are not dups. I used the…
Mark k
  • 59
  • 8
1 2 3
…
11 12