Forum Discussion

jnpb's avatar
jnpb
Helper I
4 years ago
Solved

Issues generating a YTD from previous year

Hi everyone,  I'm trying to generate a YTD from the previous year and am either using an incorrect syntax or just not going about this the correct way. Working with PBI is not normally my area of ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi jnpb ,

     

    I think it should be because your date contains timestamp. You need to create a new Date column, like this. 

     

     

    Then change the measure to

     

    Measure = 
CALCULATE (
    SUM ( 'Table'[NPSRecommend] ),
    SAMEPERIODLASTYEAR ( DATESYTD ( 'Table'[Date] ) )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • jnpb's avatar
    jnpb
    Helper I
    4 years ago

    Hi Nishant, 

    I tried to figure this out but my attempt doesn't work (I'm very unfamiliar with the subject matter). This is what I tried - can you help identify what I did wrong and how to correct it? 

     

    Measure = TOTALYTD(PREVIOUSYEAR(Query1[NPSRecommend]),Query1[Submission Date])
    • v-kkf-msft's avatar
      v-kkf-msft
      Community Support
      4 years ago

      Hi jnpb ,

       

      Please try the measure.

       

      Measure = 
CALCULATE (
    SUM ( 'Table'[NPSRecommend] ),
    SAMEPERIODLASTYEAR ( DATESYTD ( 'Table'[Submission Date] ) )
)

       

      If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
      Best Regards,
      Winniz
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • jnpb's avatar
        jnpb
        Helper I
        4 years ago

        Hi Winniz, 

        I tried this measure and got the following error: 


        The data in the submission date table are date/timestamps that are sometimes the same - i have to be able to work with duplicate dates: is there an alternative to datesytd that would work here?