Total value is not correct.

[arvindyadav]

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

Please find measure for the previous period:

previous period = 

Previous Period Profit = CALCULATE(SUM(Table1[Profit]),SAMEPERIODLASTYEAR(Table1[Date]),ALL('Table1'))

and measure for current month :

This Month Profit = CALCULATE(SUM(Table1[Profit]),FILTER(Table1,YEAR(Table1[Date])=YEAR(TODAY()) && MONTH(Table1[Date])=MONTH(TODAY())))

The total of Previous period profit displaying from 7/1/2018 to 7/31/2018 i.e, $412025.00 but I need to correct the profit to display as 7/1/2018 to 7/28/2018 i.e, the profit is $37300.13.

Thanks,

Arvind

[v-xicai]

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]

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]

Hi @v-xicai,

Any update on this?

Thanks,

Arvind

[Geradav]

Hi @arvindyadav 

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

[arvindyadav]

Hi @Geradav ,

Please find the link of sample data.

Sample Data

Thanks,

Arvind

[Geradav]

Hi @arvindyadav 

Does that correspond to what you are looking for?

[arvindyadav]

Hi @Geradav ,

Now I am getting total value perfect but date wise value is incorrect.

Please find attached.

[Geradav]

Hi @arvindyadav 

Not sure to understand you correctly.

Which part of your visual is not showing you the right result? And what result would you expect?

[arvindyadav]

Hi @Geradav ,

If you see your Image and mine Image only total of previous month matching but the individual date profit not matching where the dataset is the same.

Thanks,

Arvind

[Geradav]

@arvindyadav 

Maybe you send me your file with the DAX statement at david@fumastra.com

[arvindyadav]

Hi @Geradav ,

The problem is when I select date range day before yesterdays the data showing me the correct value but when I select date range till yesterdays the total value shows me the entire profit of a previous period month. 

[arvindyadav]

Hi @Geradav ,

Have you got any solution?