No announcements
Found 2371481 threads
-
0 Votes
Get the 30 previous days in measure DAX (SSAS Tabular)
I haven't tested this, but would this measure ...Answered | 3 Replies | 634 Views | Created by Adghar - Tuesday, February 26, 2019 3:57 PM | Last reply by auaero - Wednesday, February 27, 2019 10:39 PM -
0 Votes
SSAS 2016 - Tabular Model - Fetch Calculate Measure Name and DAX-Formula
>>Now I need the Name and DAX(Formaula) used/Written in all the Calculate Measures in the Tabular Model Cube, So that I can copy them in ...Answered | 2 Replies | 995 Views | Created by Rihan8585 - Thursday, August 23, 2018 9:22 AM | Last reply by willson yuan - Thursday, August 23, 2018 9:53 AM -
2 Votes
calculated measures in tabular model
However you can query tabular models using either DAX or MDX.Answered | 4 Replies | 1142 Views | Created by db042190 - Wednesday, March 29, 2017 10:10 AM | Last reply by willson yuan - Thursday, March 30, 2017 1:57 AM -
1 Votes
DAX - Get the previous/next row
Both PowerPivot and SSAS tabular are using DAX, if Earlier funciton works in PowerPivot , it should work for SSAS tabular also.Answered | 4 Replies | 3734 Views | Created by AmraniO - Monday, May 29, 2017 2:15 PM | Last reply by willson yuan - Wednesday, May 31, 2017 1:18 AM -
0 Votes
Define SSAS Tabular measures in batch?
If you can't wait, then I suggest getting an intern.Answered | 2 Replies | 1234 Views | Created by MikeRudz - Thursday, November 19, 2015 3:08 PM | Last reply by Darren Gosbell - Thursday, November 19, 2015 8:02 PM -
0 Votes
Text measure SSAS Tabular
Hello, Finally, i found the solution, not so good i think, but i take the attribute dimension (Name Column) into my fact table and i can create my ...Answered | 2 Replies | 1327 Views | Created by Adghar - Wednesday, December 12, 2018 8:03 PM | Last reply by Adghar - Thursday, March 21, 2019 7:21 AM -
0 Votes
Organizing measures in a separate table in SSAS tabular cube
Hello I have lots of calculated measures scattered across two tables and want to organize them.Answered | 3 Replies | 4154 Views | Created by Priyadarshini Vaishampayan - Tuesday, August 13, 2019 1:21 PM | Last reply by RichardHardy - Friday, August 21, 2020 8:54 AM -
0 Votes
SSAS 2012 Tabular
This kind of measure is not supported in Tabular model.Answered | 3 Replies | 934 Views | Created by Tiago Rente - Thursday, January 14, 2016 3:51 PM | Last reply by Simon_Hou - Monday, January 18, 2016 6:14 AM -
0 Votes
SSAS Tabular - "built-in" ?
Every table gets one of these _Count measures created, but they should be hidden by default.Answered | 3 Replies | 943 Views | Created by Sylvain06 - Friday, May 15, 2015 4:49 AM | Last reply by Darren Gosbell - Tuesday, May 19, 2015 4:59 AM -
3 Votes
DAX Measure for Returning Students?
I suggest you reading the New and Returning Customer DAX pattern article: http://www.daxpatterns.com/new-and-returning-customers/ Marco Russo ...Answered | 1 Replies | 1116 Views | Created by Ryan Smiths - Tuesday, October 28, 2014 12:15 PM | Last reply by Marco Russo - SQLBI - Tuesday, October 28, 2014 2:44 PM -
1 Votes
SSAS Scope to DAX
Also, here is a post on currency conversion.Answered | 6 Replies | 2380 Views | Created by Nik - Shahriar Nikkhah - Thursday, January 5, 2017 7:48 PM | Last reply by Nik - Shahriar Nikkhah - Tuesday, January 24, 2017 4:44 AM -
1 Votes
SSAS Tabular Model - DAX - Filtering on the Summerize function output and taking a count
I could able to create a measure in my tabular model Shwetha LAnswered | 5 Replies | 6249 Views | Created by Shwetha L - Tuesday, June 11, 2013 6:34 AM | Last reply by Shwetha L - Friday, June 21, 2013 6:32 AM -
1 Votes
SSAS Tabular - YTD calculation
Is it enough for your calculation to get the sum of the last 91 days?Answered | 16 Replies | 9175 Views | Created by NewMSSAS - Monday, October 7, 2013 10:11 PM | Last reply by Paul Diponkar - Tuesday, April 11, 2017 2:47 PM -
0 Votes
PivotTable connected to SSAS Tabular Model
Excel 2013 does not support creating ad-hoc DAX calculated measures.Answered | 1 Replies | 1426 Views | Created by GV1973 - Thursday, August 15, 2013 9:24 PM | Last reply by Darren Gosbell - Friday, August 16, 2013 4:53 AM -
0 Votes
Dynamic KPIs on SSAS Tabular Model
Hi I realize this may not have been available at the time of the post, however it is now, using Azure Analysis Services - Compatibility level SQL Server 2016 RTM (1200) ...Answered | 2 Replies | 2817 Views | Created by maxpayne2508 - Wednesday, February 19, 2014 5:59 AM | Last reply by NigelReed - Thursday, August 24, 2017 4:55 AM -
2 Votes
Extract SSAS TABULAR data into sql server table
Following is a blog talking about runing DAX via openquery to linked server to a Tabular SSAS named ...Answered | 3 Replies | 3596 Views | Created by reapeleg - Sunday, May 14, 2017 8:54 AM | Last reply by reapeleg - Monday, May 15, 2017 1:43 PM -
0 Votes
Time Intelligence DAX functions are not working in Tabular model
Learn Power Pivot and SSAS Tabular.Answered | 1 Replies | 1345 Views | Created by blezin - Thursday, February 26, 2015 10:37 PM | Last reply by Marco Russo - SQLBI - Friday, February 27, 2015 7:41 AM -
0 Votes
DAX-Multiple Measures in Single Measure
If I see your example , you have written entire code of YTD/Total Sales in Measure "AllinOneMeasure" but then what if I had one more Measure in ...Answered | 8 Replies | 1237 Views | Created by Rihan8585 - Sunday, July 22, 2018 4:08 PM | Last reply by Rihan8585 - Sunday, August 12, 2018 8:30 AM -
2 Votes
Tabular model: dimension not related to measure
So your tabular model implements a non-trivial data model in which some measures are unrelated to some dimensions.Answered | 6 Replies | 1061 Views | Created by Russ Loski - Tuesday, July 2, 2019 7:05 PM | Last reply by Alexei Stoyanovsky - Wednesday, July 3, 2019 9:05 PM -
0 Votes
SSAS Tabular - Will adding more and more measures degrade performance?
What may be happening is that you calculations may be getting more complex although you do say they are pretty simple so this may not be a problem either.Answered | 1 Replies | 701 Views | Created by VivDev - Sunday, January 10, 2016 12:19 PM | Last reply by MichaelAdrianJohnson - Sunday, January 10, 2016 5:46 PM - Items 1 to 20 of 2371481 Next ›
No announcements