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

Problems when adding a new column in the evaluate sentence in PBI paginated report

I have a dataset based on a dax code. This is the schema of the query where we use parameters to filter some tables: Declare var filtertable1 = .... @param1 ... ... var filtertablen = .... @paramn ... Evaluate sumarizecolumns ( column1, …
d2907
  • 798
  • 3
  • 15
  • 45
0
votes
0 answers

How to test output of all visuals in Power BI Report?

I'm looking for a efficient testing strategy for a PBI Report. I believe that having the output of all visuals in table format — given a certain context — could be used to compare them with the expected result. Is there a tool that allows to…
Aleix
  • 431
  • 4
  • 20
0
votes
3 answers

Is there a way to conditionally calculate numeric fields based on string values in DAX (Power BI)?

I have an interesting challenge: I have 19 metrics which may or may not have values for each facility each month. I need to have a date filter and facility filter for my users. Each facility (rows) has a total capacity. Assuming a user has selected…
IrisD
  • 15
  • 2
0
votes
1 answer

Power Bi DAX DateDiff Calculation

How do I write a DAX formula to calculate the date difference between two columns. The calculate column should be name OnTime and if true should be Y, if not, N. The difference should be in minutes. There's a fix target value which is 30 minutes…
Canthiano Prosky
  • 25
  • 3
0
votes
0 answers

I need to subtract Time From same column by applying filters on it

I have [scan Time] column and [Location] column which have different locations like Security T2, Post security T2 DOM , Post Security T2 INT. So want to subtract Scan Time of Post security T2 DOM and Security T2 also Post security T2 INT and…
Dnyanu Jawale
  • 1
0
votes
0 answers

Joins in power bi

I’m trying to perform a left join from a primary table to two other tables so that only details in the primary tables show. The dax function I used ( NATURALOUTERLEFTJOIN) can only do two tables , I.e. left table and right table
Eniola Abolade
  • 1
0
votes
0 answers

Dax Studio and Power BI returning very different results

I have a difference between values returned in Dax studio and Powerbi desktop. My main table contains records, job id offered date, communication method. These are showing jobs offered to 3rd parties and if they accepted or not. I am trying to…
jason millington
  • 5
  • 2
0
votes
0 answers

DAX Formula to add the Values in Table1 based on a given criteria

How can i add the values in a given column in Table1, using a formula in Table2. I need to add all values that meet the condition in Table1[ColumnWithCondition] and show the result in Table2, based on what date the Value in Table1 is active. this is…
Lupus
  • 25
  • 5
0
votes
1 answer

Rankx by year in Power BI Dax

For each couple year-month I need to create the ranking of my average revenue. So far this is what I have been able to reach: However, what I need to do is to re-start the ranking when the year changes. But righ now is a consecutive ranking, it…
d2907
  • 798
  • 3
  • 15
  • 45
0
votes
0 answers

Optimize DAX query to calcualte initial sales order status and final sales order status

Greetings, I have a requirement where i need to calculate the sales order status from the point of a product was ordered. the data which i have for one of the sales order id is as below for a customer. Sample Data: let Source =…
Mohan.V
  • 141
  • 1
  • 1
  • 10
0
votes
1 answer

How to measure a SUM of any value for each week for the current month filtered

I have a visual that I need to calculate the total volumes of sales, I have linked this table of volumes with another table that contains month and week numbers. I'm having trouble writing a measure that calculates the volume of sales in the first…
Rodrigo Camargo Jr.
  • 9
  • 3
0
votes
0 answers

Powerbi calculating sum all other values except selected value using two slicers

How to write a powerbi measure for a second slicer which will calculate the sum of all other category except the values selected in the first slicer?
lesa Bee
  • 51
  • 1
  • 5
0
votes
2 answers

Complex PBI Dax Use Case

I have this complex use case, I need to get a list of projects or flag them in DAX based on the following: -if a project has multiple expense types then flag : The project that has 5% or more in variance in **more than one** expense type but…
Rachel
  • 208
  • 1
  • 5
  • 18
0
votes
0 answers

How to calculate YoY in Power BI dynamically?

I have a column Date with "Date" and "Cost" that has cost numbers here. Below is how my data looks…
Legionomous
  • 1
  • 2
0
votes
1 answer

How to calculate Monthly Recurring Revenue using DAX?

My end goal is to have a Monthly Recurring Revenue for a subscription service. Example: Rules: Contract column must be different than 0 The following table is already related to the calendar dimension using another…
rodrigo nilo
  • 3
  • 2
1 2 3
…
11 12