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 ,

 

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