Need Help with Measure

[Anonymous]

Hello All ,

I need your help with below measure . I want to display the sum of sales between start date and end date as below but somehow iam not able to get desired result.

Measure=
var a=selectedvalue(DateTable[Date])
var b=a-6

var c=calculate(Sum(Data[sales]),DATESBETWEEN(Data[Approval Date],b,a)
return c

some how i was able to get sales only for end date a.

Please help with the solution for this.

TIA

[v-luwang-msft · Accepted solution]

HI @Anonymous ,

Check the table relationship, when there is a relationship between the data table and the date table, the measure is invalid.

And you could download my pbix file to check your file.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien