How to apply the 4-4-5 monthly accounting calendar format to an existing report?

Power BI
1

Hi there,

I have been asked to add monthly and YTD reporting on the 4-4-5 accounting format to an existing report. The existing report is based on the regular calendar. What is the best way to go about incorporating this new requirement into the existing report?

Would it be best to simply add additional columns to the existing date calendar or would it be best to have a dedicated 4-4-5 calendar?

Alternatively, would DAX formulas be the way to go?

Thank you!

2

Hi @powerbideveloper,

The Date dimension should contain all attributes belonging to a date. In by far most Date tables you’ll find both Calendar- and Fiscal attributes, side by side.

As far as where to add them, at the source - would be my advise. If that’s external see if you can arrange it there, else power query and if all else fails calculated columns.

Cheers

1 Like