Home Dashboard Directory Help
Search

SWITCH and LASTNONBLANK can't be combined in a PowerPivot calculated measure by MarkGStacey


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 788462
Opened: 5/22/2013 11:35:16 PM
Access Restriction: Public
1
Workaround(s)
view
0
User(s) can reproduce this bug

Description


When putting a measure in the form :

X:=SWITCH ( LASTNONBLANK(DatePeriods[Period];1=1)
; "Day"
; 1
)

This works, however adding a second condition:
X:=SWITCH ( LASTNONBLANK(DatePeriods[Period];1=1)
; "Day"
; 1
; "Month"
; 2
)

consistently crashes Excel 2013

Details
Sign in to post a comment.
Posted by Microsoft on 5/23/2013 at 1:58 PM
Thanks Mark, we'll investigate this issue.

Thanks,
Kasper
Sign in to post a workaround.
Posted by MarkGStacey on 5/22/2013 at 11:36 PM
First create a new measure containing the LASTNONBLANK only, then reference that measure in your new measure