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
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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

VasTg ,

 

Did you link it to a datetable? I have my data set up to a datetable. Due to the privacy of the data model, I cannot my pbix. However, I have reviewed your sample but i see you have Calendar year. I have a FY starting from Jul-Jun. And somehow when I place the total monthly into the cad visual, it automatically adds both months just as the YTD.

 

 

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

    Anonymous 

     

    I have a relationship between the date and fact based on the date column.

     

    Of course it will add when you choose FY. You should filter for month.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      VasTg ,

       

      I did filter for month but they both remain the same 49.

       

      I amnot sure why this is going on

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        VasTg Can you share your pbix file to compare with mine.

         

        I ahve tried different formulas to no avail.

         

        Thanks