All Questions
Tagged with ssas-2012 powerpivot
4 questions
1
vote
0
answers
1k
views
SAMEPERIODLASTYEAR for only values in current year
I'm trying to show the value from prior year for products. I only want the products that are present in the current year to show.
What I would like:
Product SamePeriodSalesLastYear
1, ...
- 33
1
vote
1
answer
487
views
Multiple filters in DAX with OR Keyword
I have a requirement where I need to evaluate column from multiple tables and select required records from my Fact table in my SSAS tabular Model.
Eg:
Pick Records from FactA where:
('DimA'[DimA ...
- 967
0
votes
1
answer
134
views
Is there anyway to connect to SSAS using Service account while using powerpivot to get the data from cube?
We are using Excel 2010 into our office to produce some reports. We are using powerpivot plug in to connect to SSAS cube. The only problem is when, it is using windows authentication and I want to use ...
- 403
1
vote
2
answers
2k
views
Dax formula to calculate cumulative students
I am building first cube in SSAS 2012 Tabular modeling. I got one fact table contains following columns
TermDate StudentKey PaperKey marks CumulativeNoOfStudents
...
- 11