Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
7 years ago

Total value is not correct.

Hi Team,   I am getting total value Incorrect. The total value display in power bi for the entire month of the previous period but I need only total value for the previous period for current date ...
Need Help
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi arvindyadav ,

 

You can try to create a measure like DAX below.

 

Previous Period Profit = CALCULATE(SUM(Table1[Profit]),DATEADD(Table1[Date],-12,MONTH))

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

arvindyadav's avatar
arvindyadav
Post Partisan
7 years ago

Hi v-xicai ,

 

Can you please read the Message once again I have made changes. your Dax is not works for me.

The result I am getting after applying your measure is:

 

  • arvindyadav's avatar
    arvindyadav
    Post Partisan
    7 years ago

    Hi v-xicai,

     

    Any update on this?

     

    Thanks,

    Arvind

    • Geradav's avatar
      Geradav
      Responsive Resident
      7 years ago

      Hi arvindyadav 

       

      Can you provide a file with some sample data? That could help better understanding the situation