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

Quick calculation where numerator depends on filters but denominator is fixed (DAX)

I have a table in PowerBI called "Dati Popolazione ATTR", which is something like: Region | Province | Town | Population | Males | Females | Attribute R1 | P1 | T1 | 1000 | 500 | 500 | A1 R1 | P1 | T1 | 1000 …
coelidonum
  • 523
  • 5
  • 17
0
votes
1 answer

Is it possible to use a dynamic value in a DAX formula?

I'm working on a BI project with Visual Studio and Power BI. I get the sales of several stores and in Visual Studio I made a column calculated with the following formula : = SWITCH ( TRUE(), Y2_Sales' [storename] = "UK-RC O/O NEWQUAY",…
Theo27
  • 385
  • 4
  • 17
0
votes
3 answers

DAX use username function in table look up

I need to create a table based on a lookup. The problem is that in the CALCULATETABLE I cannot use username() function. CALCULATETABLE ( LOOKUPVALUE ( 'User Table'[SOC], 'User Table'[username], USERNAME () ), 'User Table'[username] =…
power83
  • 69
  • 8
0
votes
1 answer

force 0 when blank with addcolumn summarize excel 2016 dax for more accurate averages

I have one table that has three columns: lisa, customers and activity_type. I want to count the number of rows by customer and activity type and then average them over all customers by activity types. If this were a table in sql, I'd do SELECT …
Henrietta Martingale
  • 771
  • 8
  • 27
0
votes
1 answer

Date diff using dates in the same column DAX

I have a dataset where I am trying to calculate the user response time to dealer note using the note date of every action. Here is my sample data look like, I've calculated this in hive query using lag, lead, and min window functions, but my user…
Rahul
  • 467
  • 1
  • 8
  • 24
0
votes
1 answer

DAX - Querying Data with DAX combine data from two tables

I am new to DAX and am pulling Tabular Data from Analysis Services. There is a lot of data and I only want to pull certain columns from different tables in the cube. I can pull a couple of columns from one table but not sure how to combine it.…
Melissa
  • 15
  • 4
0
votes
1 answer

Powerbi Measure to Ignore the decimals in negative number

The following measure var growth = IF([value]>0,"up by ", IF([value]=0,"flat at ", IF([value]<0,"down by "))) With the above measure the values -0.1 or -0.001, etc are shown as down by while it should be shown as flat at. Please let me know…
Vanessa Pinto
  • 11
  • 4
0
votes
0 answers

PowerBi measurements on one table visual breaks filtering of table with slicer and return all data

I have trouble setting in Powerbi a tile table with 4 field and 2 measurement where the second measurement has depenency on the first. I have a data table with 4 field. Task Categories Tasks Target Date Completion Date categories and tasks are…
kyrpav
  • 756
  • 1
  • 13
  • 43
0
votes
1 answer

DAX: Min(Start_date) based on previous date

Please lend your hand to resolve my issue facing in DAX logic. Table I need I don't know how to proceed with Dax could you please share me your ideas Edit2: What if my data is like this Batches -B will start on day 1 and complete on next…
prabhu sundararaj
  • 15
  • 5
0
votes
1 answer

Why isn't the DAX Editor available in Visual Studio 2017?

Why isn't the DAX Editor available as an extension in Visual Studio 2017? If it isn't available is there an alternative to it? How do I get a list of defined measures in DAX studio similar to the "Model.dax" file generated in Visual Studio?
Panchali Nanayakkara
  • 67
  • 6
0
votes
2 answers

Keep all no blank rows in matrix in PowerBI with DAX

In PowerBI, I have a table with 4 columns: ItemId OptionId Price IsItemSold For each ItemId in the table, we have the same count of OptionIds with a flag IsItemSold which is "Yes" if the Option is sold and "No" if the option is not sold. I created…
MCrassus
  • 149
  • 1
  • 6
0
votes
1 answer

Power BI change original table name which is displayed in Daxstudio

I noticed very odd thing that Daxstudio allows you to view original table name. It is a bit niuanse because when you rename table created in M then Daxstudio still refers to it using original table name, not the new name. Here is how to reproduce…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
0
votes
3 answers

How to check in Daxstudio which DAX query has better performance?

How to check which of the two DAX queries has a better performance using Daxstudio. In the example the queries return exactly the same results. However the stats differ showing not clear hints. What usuful information can we grasp from the…
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
-1
votes
1 answer

how do i join two tables using dax

i have two tables in power bi that i am trying to join or lookup. the period table has the days, months, and month id. the data table has the days and data. i need to pull the month id from the period table into the data table so that i have a table…
Yashvi
  • 1
  • 3
-1
votes
1 answer

SQL Script in DAX ( Many different Joins )

I have a problem in Power BI with DAX, i want to do SQL joins in Dax , i made my data modelling with my tree tables Table 1 enter image description here table 2 enter image description here table 3 enter image description here I want to do with DAX…
Arthur_75
  • 35
  • 2
1 2 3
…
11
12