Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
it seems you are interpreting the underlying numerical value of an already dual loaded date field with the date#() interpretation function.
Try to just use the formatting Date() function
Date(yourdatefield, 'MMM-YY')
hope this helps
regards
Marco
Conditional dimension or you meant calculated dimension? Try this
=Date(Date#(YR_MTH_KEY, 'YYYYMM'), 'MMM-YY')
I tried out your expression in the calculated dimension. This is what I got..:(
Can you post a screenshot of just YR_MTH_KEY?
I mean it works in the sample you have provided, right? I guess the only other things you can try this
=Date(Date#(Text(YR_MTH_KEY), 'YYYYMM'), 'MMM-YY')
it seems you are interpreting the underlying numerical value of an already dual loaded date field with the date#() interpretation function.
Try to just use the formatting Date() function
Date(yourdatefield, 'MMM-YY')
hope this helps
regards
Marco
Sunny, It worked with =Date(YR_MTH_KEY,'MMM-YY')
Hahahaha okay