derived column if else

Excel Syntax for IF else statement:

=IF(A=B,C,D)

SSIS Derived Column Syntax
A == B ? C : D


http://www.josefrichberg.com/journal/2009/8/24/if-then-else-statement-in-ssis-derived-columns.html

Derived Column mmm date conversion

REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE([DateColumn],"Jan","01"),"Feb","02"),"Mar","03"),"Apr","04"),"May","05"),"Jun","06"),"Jul","07"),"Aug","08"),"Sep","09"),"Oct","10"),"Nov","11"),"Dec","12")

Last Refresh in Power BI

http://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

Dealing with long text in ssas cube

How to place nvarchar data with max size in SSAS Cube 2012 version

In 2012 visual studio if we drag varchar (max ) attribute it automatically takes with data size zero.  And doesn't set any data size property for that attribute. So we have to add it manually in XMLA code . Right click on dimension->go to code mode  add data size property like belowone

<DataType>WChar</DataType>
<Data size>163315555</Data Size>