Display the 2 KPI for the Current Date and the Comparable Date

[zjalalacssi]

Hi Everyone,

I have an issue displaying Two Kpis with different Dates on the same Row.

I have a calendar with these values:

This calendar is linked to my fact table using the Date field

i need to display a table with the following informations:

Date	Kpis	Kpis Comparable Date
2018-01-06	40	10  (2017-01-07)

Using Set Analysis i have 2 rows Displayed like this:

Date	Kpis	Kpis Comparable Date
2018-01-06	40	0
2017-01-07	0	10

Can you help me figure it out please?

Thank you

[zjalalacssi]

Thank you very much for taking the time to help me, i will test your solution on my app (since i have a more complex modele) and let you know soon.