GOC Power BI tips #3 – Automatic translation from an English to a French Month

So this is a “stepping stone”  post that will take us to the next blog in which will create a French Date column that is automatically translated from a regular date column. Even though this is an interim step, having… Read moreGOC Power BI tips #3 – Automatic translation from an English to a French Month

GOC Power BI tips #2 – Automatic creation of Fiscal Month and Period Calculated Columns

So following on from our last post where we took a regular date column and converted it into a GOC fiscal year, in this post we are going to automatically create GOC quarters (Qtr 1 = Apr-Jun, Qtr 2 =… Read moreGOC Power BI tips #2 – Automatic creation of Fiscal Month and Period Calculated Columns

GOC Power BI tips #1 – automatically converting a date to GOC fiscal Year

In this first COG Power BI Tips series we are going to be looking to convert a regular date column to a GOC fiscal year. Typically this might be done with a lookup table but I am going to show… Read moreGOC Power BI tips #1 – automatically converting a date to GOC fiscal Year