Forum Discussion

LyncoData1's avatar
LyncoData1
Helper I
6 years ago
Solved

PYTD Feb Duplicates

I am calulating PYTD for year 2020. However, the month of Feb in 2020 has duplicated the same values from Feb 28th to Feb 29th (159.20). I am not sure if it is because the month of Feb 29 days compar...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi LyncoData1 ,

     

    Modify your measure as below:

     

    PYTDSales =IF(SELECTEDVALUE('DimCalendar'[DateKey])=DATE(2020,2,29),BLANK(),
CALCULATE(
[NetSales],
SAMEPERIODLASTYEAR(
'DimCalendar'[DateKey]
)
)

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi LyncoData1 ,

 

Modify your measure as below:

 

PYTDSales =IF(SELECTEDVALUE('DimCalendar'[DateKey])=DATE(2020,2,29),BLANK(),
CALCULATE(
[NetSales],
SAMEPERIODLASTYEAR(
'DimCalendar'[DateKey]
)
)

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

 

  • LyncoData1's avatar
    LyncoData1
    Helper I
    6 years ago

    This worked! Thank You!