Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

The SQL Server Analysis Services (SSAS) tabular model is an in-memory, column store relational data warehouse constructed with tables which can have multiple columns of data. SSAS Tabular is geared for fast querying and high data compression. The Tabular Engine is the same one used in Power BI, Azure Analysis Services, and Excel Power Pivot.

869 questions
0
votes
1 answer

How to Calculate Sum untill start of month of a given date in DAX

I would like to calculate Sum(QTY) until the start date of the month for a given date. Basically I can calculate Sum(QTY) until given date in my measure…
bsaglamtimur
  • 385
  • 1
  • 7
  • 17
0
votes
1 answer

Functionality Similar to SUMIFS with DAX?

Sample workbook: http://1drv.ms/1VDgAjf I've got a table similar to: ActiveDate CommenceDate Amount ------------------------------------------- 20150115 20150201 10 20150115 20150201 2 20150223 20150301 3 20150223 20150202 …
m1nkeh
  • 1,337
  • 23
  • 45
0
votes
2 answers

Unrelated Column reference with filter syntax error

Im using SSAS Tabular. Trying to insert a column which gets data(OrgNumber) from an unrelated table called…
Blixter
  • 338
  • 4
  • 12
0
votes
1 answer

Drilldown query from SQL to DAX

I have been thinking about moving some drilldown queries from T-SQL to DAX to improve performance. I have not really used DAX that much as a query language and was struggling to find examples that would let me convert the following simple SQL query.…
jeremyh
  • 612
  • 4
  • 14
0
votes
1 answer

Calculating PERCENTILE in DAX

I have googled and keep ending up with formulas which are too slow. I suspect if I split the formula in steps (creating calculated columns), I might see some performance gain. I have a table having some numeric columns along with some which would…
SouravA
  • 5,147
  • 2
  • 24
  • 49
0
votes
2 answers

relationship filter in powerBI or powerpivot

i am using the powerBI tools (powerpivot) to create a data model. i am done the model. the model include the product, customer dimensions and sales fact table. i have made the relationship and hierarchy in the model. now i have a requirement to show…
Atul Bansal
  • 151
  • 2
  • 12
0
votes
1 answer

MSSQL query to retrieve DAX formulas from tabular model

First I would like to stress that Im quite new with the Analysis Services, so please forgive me if my question is not adequate. I have received a task to display in Sharepoint list DAX formulas from existing tabular model and Im struggling to obtain…
szachmat
  • 158
  • 13
0
votes
2 answers

Conditional distinct count based on a measure in DAX

I am trying to do this with DAX and unable to get the correct distinct count... AccountID OrderDate Product SalesAmount DiscountAmount 1023 Nov-14 Product001 $0 $5.00 1045 Nov-14 Product001 $30.00 …
sameer
  • 163
  • 2
  • 6
0
votes
1 answer

Calculated measure working in Power Pivot but not in Power BI Preview Designer

I am new to Power BI and I am suppose to build some dashboards using the Power BI Preview Designer. I have a data model in Tabular Model, and I am creating a data connection to the Power BI Preview report, I have some calculated measure which are…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
2 answers

Dates Appearing in Tabular Model but not appearing on Pivot table

I am using SSAS tabular Model 2012, in tabular model all dates are appearing correct in date column but not when i drag attribute to my pivot table it shows only one date. Does anyone has the solution of this issue. I am using o365 Office Dates in…
BIDeveloper
  • 767
  • 3
  • 14
  • 28
0
votes
0 answers

How Can SSAS cause excel manual filters to reset?

I have multiple end users linking to a Tabular Analysis Server data cube. The cube is refreshed (full) every night when the BI datawarehouse it draws from is updated. This setup has been in place for over a year. One morning several users reported…
PaterVater
  • 1
  • 1
0
votes
1 answer

Tabular Model Not Caching Results

Can anyone, someone point me in the direction of how to troubleshoot why a Tabular model that I have built does not seem to want to cache query results? It is my understanding that MDX queries to Tabular model will be cached, however with our model…
m1nkeh
  • 1,337
  • 23
  • 45
0
votes
0 answers

Slow Query Performance During Process Of SSAS Tabular

As part of My SSAS Tabular Process Script Task in a SSIS Package, I read all new rows from the database and insert them to Tabular database using Process Add. The process works fine but for the duration of the Process Add, user queries to my Tabular…
Abiete
  • 105
  • 2
  • 10
0
votes
1 answer

How to transfer data from Tabular model (SSAS Tabular) to Relational Database?

I am new to SSAS and Tabular model cubes. I have a data migration task that aims to import data from a Tabular model into a SQL Server database. I have tried SSIS with not success. Using OLEDB Data source connected SSAS instance with Tabular…
Ross Brigoli
  • 676
  • 1
  • 12
  • 22
0
votes
1 answer

SSAS 2012 TABULAR : Data load testing using MDX

I have a model developed in Tabular 2012. When I connect to the cube, I see FACT and DIMENSION tables listed. I am not a developer - I am just asked to test the data load. I just need to locate an example record from my source DB in FACT( Or…
varunmagical
  • 43
  • 7
1 2 3
…
57 58