That should be a DAX formula. Click on the Data Tab in the black bar on the left hand side and then click on Calculated column formula. Write this formula in the relevant table
Hope this helps.
Hi Ashish, BIG Thanks for the help. This worked.
One additional challenge i faced is that resultant measure from formula suggested is set up as "Text" field. I am not able to sort the chart based on calendar months.
Thanks again for guidance and help !!
You are welcome. Please just Google for "Sort months in PowerBI desktop". Read the answer by mfhussain here - https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/td-p/9237
This does not work on Direct Query model
What if I have
is the case and we need to sort using the month, meaning all the vlaues from each month, if I am not wrong , I need to create a measure for that but could anyone guide me a bit on this , how I will do it ?
I have three months: Feb, Mar, Apr but its showing in alphabetical order: Apr, Feb & Mar
How shall I resolve this issue?
@Ashish_Mathur wrote:Hi, Try this =FORMAT(Data[Date],"mmm-yyyy") Hope this helps.
See my post data 6 MArch 2019. I have shared a link there.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!