Good Afternoon,
Hopefully someone can help me with this issue I have an Excel Document similar to below, with the fields all showing their format as "General" as this is how the data is sent to me.
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>I am looking to:
- Find a way to change the month from 1/2/3/4.... to Jan/Feb/Mar etc.
- Have Q1 recognized as a period of time
- Have Year (2017/2018 etc) show as 2017/2018 but formatted as a year
The reason for doing this is so that I can start looking at Power BI reports showing MoM, QoQ and YoY data. I didnt publish this in the Power BI section as I believe this is an Excel query.
Many Thanks in advance for any help you can provide!
Hopefully someone can help me with this issue I have an Excel Document similar to below, with the fields all showing their format as "General" as this is how the data is sent to me.
<tbody> </tbody> |
<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>
- Find a way to change the month from 1/2/3/4.... to Jan/Feb/Mar etc.
- Have Q1 recognized as a period of time
- Have Year (2017/2018 etc) show as 2017/2018 but formatted as a year
The reason for doing this is so that I can start looking at Power BI reports showing MoM, QoQ and YoY data. I didnt publish this in the Power BI section as I believe this is an Excel query.
Many Thanks in advance for any help you can provide!