Forum Discussion

ROCKYDO12's avatar
ROCKYDO12
Icon for Helper III rankHelper III
4 years ago
Solved

YTD and LYTD calculation Issue

Hello,   I am trying to create some KPI's and I am using the following calculations for CYTD Sales and LYTD Sales:   CYTD Sales: CALCULATE(SUM('Sales Base'[Amount]),DATESYTD(('Calendar'[Date]),"3...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Hi ROCKYDO12 ,

 

How does the relationship between the two table flow?

  • ROCKYDO12's avatar
    ROCKYDO12
    Icon for Helper III rankHelper III
    4 years ago

     

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

      Hi ROCKYDO12 
      I was referring to the cross filter direction. 

       

      • ROCKYDO12's avatar
        ROCKYDO12
        Icon for Helper III rankHelper III
        4 years ago

        Single, same as yours! Not sure if this could play a factor but my calender table the date has a hierarchy and my sale table the date table does not.