straight table with different date columns

[MarkusG]

Hi experts,

i have to solve a Problem with an straight table.

I Need a table without dimensions but in different time lines.

All KPI´s i like to Show are calculated and they Need to compared to different times like the Excel example attached.

Thank you and best regards

Markus

[vinod22kv · Accepted solution]

Hi,

By using valuelist and column function we can solve this please check.

Thanks and Regards,

Vinod.

[MarkusG]

Hi Vinod,

thank you for your quick answer.

It worked so far that i was able to create my columns as needed and YTD is running correct.

But i struggle now by creating variables for yesterday and Prior year.

in the scrennshot just the first line has the correct Formula for calculation ...

i did it like this:

in scrip:

variable manager:

expression:

Thank you

Markus