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

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