Forum Discussion

LyncoData1's avatar
LyncoData1
Helper 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
Community 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!