Home
> SQL Analysis Services > LastNonEmpty on SSAS 2005 Standard
LastNonEmpty on SSAS 2005 Standard
Method 1:
CASE WHEN NOT IsEmpty([Measures].[MeasurePutToColumn])
THEN [Measures].[MeasurePutToColumn]
ELSE [Time].[Calendar].PrevMember
END
Method 2:
IIF( NOT IsEmpty([Measures].[MeasurePutToColumn])
,[Measures].[MeasurePutToColumn]
,[Time].[Calendar].PrevMember
)
Categories: SQL Analysis Services
Comments (0)
Trackbacks (0)
Leave a comment
Trackback