martingaleh
Board Regular
- Joined
- Jul 18, 2011
- Messages
- 83
I hope it is abundantly obvious what I'm trying to do
cubevalue("ThisWorkbookDataModel",[Measures].[sumAmt],
CUBESET("ThisWorkbookDataModel","
Filter(
crossjoin([dDate].[FiscalYear],[dDate].[FiscalYear]),value([dDate].[FiscalYear].Value)<2018||(value([dDate].[FiscalYear].CurrentMember.Name)=2018&&value([dDate].[Weeknumber].CurrentMember.Name)<14)
)
"))
I just want in a cube value a sumAmt where the fiscal year is < 2018 or fiscal year = 2018 and date is less than 14
cubevalue("ThisWorkbookDataModel",[Measures].[sumAmt],
CUBESET("ThisWorkbookDataModel","
Filter(
crossjoin([dDate].[FiscalYear],[dDate].[FiscalYear]),value([dDate].[FiscalYear].Value)<2018||(value([dDate].[FiscalYear].CurrentMember.Name)=2018&&value([dDate].[Weeknumber].CurrentMember.Name)<14)
)
"))
I just want in a cube value a sumAmt where the fiscal year is < 2018 or fiscal year = 2018 and date is less than 14