Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need Help With Monthly Total Vs YTD

Hello All, I have a data set from an access date base that looks like the follow: Month                                                   Total Monthly X 11/14/2019                                ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

VasTg ,

 

This is the YTD formula I used: 

 

  • VasTg's avatar
    VasTg
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Anonymous 

     

    Based on the input data you should get 21 for 2020. Could you please post sample data and DAX you used to calculate the YTD and monthly measure and the expected output to better answer your question?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      VasTg  Many thanks fro your help thus far.

       

      Those are the only two pieces of information in the data as previoulsy posted. I picked the monthly total from the main table since its already aggregated(value).

      YTD dax is as follows: Calculate(Sum(Tablename[monthly value]),Filter(All(Datetable[date]),datetable[date]<=Max(Datetable[Date])).

      Expected output when FY and Monthname is applied:

      Month                YTD
      21                          49

      • VasTg's avatar
        VasTg
        Icon for Memorable Member rankMemorable Member
        6 years ago

        Anonymous 

         

        You stated the problem is with Month value is not showing for the correct month. I tested with your input data and I see the correct value. Could you upload your PBIX file to check what the error is.

         

         

        If it helps, mark it as a solution

        Kudos are nice too.