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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 788462 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/22/2013 11:35:16 PM
Access Restriction Public


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

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