I am having month field like "May-2017" .Here I need to get the Previous year data. So when I use Year(Month) or any other functions in the field I am getting numeric values something 20.2K etc. Kindly let me know how to fix the same
Are you sure it is a date format?
Did you try to cast it?
Hi Jaya Prakash,
Maybe like this
Year(date(<your field name>))
This is what I use to get all the months in 2017 that I have data for.
Let ProdCurrentYear= Date(Today(), 'YYYY');
We have an option to change the format of the expression from Auto to nuumber in properties->Data->Measures->Expression, this may helps.
Just change your x-axis as follow:
Hi Jaya prakash,
I think the date is in string format, if you require the year value you can use the string function to extract the year alone.
For example right(Month,4) will give the year part alone which you can use it in your calculation.
Retrieving data ...