Need to create YOY and QOQ

@putturps,

Wow, that’s a strange restriction that is really gonna put you at a disadvantage and make what otherwise would be a simple calculation quite difficult.

I think if I had to do it this way, I would try the following:

Within each time intelligence measure, use the CALENDARAUTO() function combined with ADDCOLUMNS to create a virtual date table within a variable. Then build the time intelligence calculations off of that virtual table.

https://info.enterprisedna.co/dax-function-guide/calendarauto/

https://info.enterprisedna.co/dax-function-guide/addcolumns/

i hope this is helpful.

  • Brian
1 Like