Forum Discussion

melg's avatar
melg
Frequent Visitor
4 years ago

Parallel Period producing the same result as current period

Hi there,   I have created the below expression to populate a line graph. This works perfectly for the current period.    Gross Deals Posted = SWITCH(        SELECTEDVALUE('Grouping'[Group]),...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

melg , You should use Date table for that

 

Gross Posted Deals 1YR =
CALCULATE([Gross Deals Posted],
SAMEPERIODLASTYEAR('Date'[Date],
-12,
MONTH)
)

or

Gross Posted Deals 1YR =
CALCULATE([Gross Deals Posted],
SAMEPERIODLASTYEAR('Date'[Date])
)

or

Gross Posted Deals 1YR =
CALCULATE([Gross Deals Posted],
dateadd('Date'[Date],
-12,
MONTH)
)

 

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

melg's avatar
melg
Frequent Visitor
4 years ago

Hi there, thank you for your response!

I tried both the SAMEPERIODLAST YEAR and DATEADD and it produces the same result, however this time there is only a value populating for October....

 

I am using ReportingDate from my date table called pavw_Dates.

 

 

Thanks. 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    melg , Use date table, that is marked as date table, to make time intelligence work.

     

    I also see a role of an independent table here. As you are displaying 12 month , when one month is selected 

     

     

    refer

    Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw

     

    Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI