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.


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

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

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

Thanks,
Kasper