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

Power BI- Need to show data from latest week day

I have a column that displays data from the function today-1 where it shows yesterdays data. I placed it in a filter to only show the "true" values. The issue I am having is I need to show yesterdays data but I need to exclude the weekend.…
k. hens
  • 19
  • 1
  • 4
1
vote
0 answers

PowerBI calculated column to convert a string to a sortable value

I'm trying to "order" a group of date bands for an AR aging project in a PowerBI matrix visual. By creating a calculated column and have successfully used this format in the past. Month Name = SWITCH('3CashAgingAnalysis'[Financial…
JL Thalacker
  • 45
  • 7
1
vote
0 answers

DAX measure for Slicer based on dates period and returns dates

I have a Date table and a FactSales table and their relationship is Date[date] and FactSales[Date]. I have a measure that sum sales e.g Total sales = SUM(FactSales[sales]). I have a table called…
Mike Eale
  • 101
  • 1
  • 9
1
vote
0 answers

Eliminating repetitive Storage Engine queries in Power BI

Please see the Power BI model file attached here. I have an Activity table and I'd like to plot on a Line chart, the number of users that were active in the last 365 days as on the date of X Axis. Hence, I created a date table, but it is not related…
Shahid Thaika
  • 2,133
  • 5
  • 23
  • 59
1
vote
1 answer

Power BI Ignore Rounding in Money values

Round values Why does Power BI (Dax query) always round values? Example: 12345.678 Power bi rounds to 12345.68 EVALUATE ROW("TEST",FORMAT( 12345.678, "Currency") ) Would it be possible to have two decimal places and not round, like 12345.67 in…
Tadeu Mansi
  • 11
  • 2
1
vote
1 answer

How to export table visual with conditional formatting from Power BI to Excel?

I have a table that I want to export to excel with conditional formatting inclusive from Power Bi table visual. How should I go about doing so? I would like to retain it in an as-is manner if possible. Is there a way to maintain the formatting and…
konsama
  • 327
  • 2
  • 12
1
vote
1 answer

Is there a way to export Power BI tables into excel?

I am trying to create a solutions process and the end-users are comfortable in Excel. Is there a way to export the tables in power bi into excel for use? I have DAX add-in if there is a way to do so with that. I have everything able to process as…
konsama
  • 327
  • 2
  • 12
1
vote
1 answer

DAX : Need a replacement of SWITCH due to Resource Memory Exceeds

Background: I have to switch between 55 measures and 16 dimensions at the same time in the query. My main query is: MetricMeasure:= CALCULATE( , USERELATIONSHIP( Interface[Values], …
Nim Nagpal
  • 49
  • 3
1
vote
1 answer

How can i convert sql query into dax query

I want to convert sql query into dax in power bi my table is:- channel advertiser yr colors pepsi 2019 colors apple 2019 colors pepsi 2018 colors google 2018 colors lux 2019 I have tried sql query to find new advertiser:- select…
Aditya Ranjan
  • 135
  • 1
  • 2
  • 11
1
vote
1 answer

DAX STUDIO - Using a column var result as input on Evaluate Function

In DAX Studio I'm evaluation the next code: EVALUATE ADDCOLUMNS ( 'Parent Child', "Path",PATH('Parent Child'[EmployeeKey],'Parent Child'[ParentEmployeeKey]), "Path Length", PATHLENGTH(PATH('Parent…
d2907
  • 798
  • 3
  • 15
  • 45
1
vote
0 answers

How to change database in Daxstudio

What is the syntax switch database in DAX studio when connected to Azure analysis services ? Like how we have in SQL server Use [DATABASENAME]
DINESH KUMAR S
  • 11
  • 1
0
votes
0 answers

DAX query for tables not directly related

I've 4 tables, all in relations one to many. Table1(one) to (many)Table2(one) to (many)Table3 etc. I need to sum data in column value from Table4 for every record in Table1. Table1 and Table4 are not directly related. Any ideas? I'm new to DAX and…
Zamash
  • 1
0
votes
0 answers

Calculate NPS score by attribute using DAX

I have below columns: ID 1, 1, 2, 3, 3, 4... Attribute (4 attributes) Online booking, In flight wifi Service Services in the plane Cleanliness Value 4 5 6 ..., Customer type: first time returned I would like to calculate NPS score and visualize it…
Andra Enache
  • 1
  • 1
0
votes
0 answers

How to Rankx and reset count where yyyymm Date gaps exist

How can I add a condition to the below dax to identify the gap between 202209 and 202305 and reset the count? -- Calc Column Active_records = var _GP = Table[GP] var indv_id = Table[ID] var _end_date = Table[DATE] var _DATE =…
SamR
  • 517
  • 3
  • 10
  • 24
1 2
3
…
11 12