Forum Discussion

LyncoData1's avatar
LyncoData1
Icon for Helper I rankHelper I
6 years ago
Solved

PYTD

Hello,    I am having trouble with pulling Net Sales for the month of March. I am trying to compare current year sales to prior year sales and drill down. I am comparing Net Sales for the full year...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi LyncoData1 ，

     

    I‘ve tested your measure with my sample data and it works fine.You need to use the dimCalendar [date]  as the slicer,then you will see:

     

    Do remember to create a relationship between FactNetSales table and DimCalendar table.

     

    Here is my .pbix file.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
     
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi LyncoData1 ，

 

I‘ve tested your measure with my sample data and it works fine.You need to use the dimCalendar [date]  as the slicer,then you will see:

 

Do remember to create a relationship between FactNetSales table and DimCalendar table.

 

Here is my .pbix file.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
  • LyncoData1's avatar
    LyncoData1
    Icon for Helper I rankHelper I
    6 years ago

    Thank you so much! This worked. 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 is a day longer compared to previous years where Feb is typically 28 days. When I only bring in Net Sales for 2019 the number does not duplicate. However, when I use PYTDSales measure the numbers duplicate themselves. Do you have any insight on how to fix?