Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help with Measure

Hello All,    Hope you are doing well 🙂   I have a measure as mentioned below in pbix which is used to sum of sales for last 7 days . but unfortunately i was not able to see any result in visual...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi dhruvinushah 

Thanks!

In this scenario, create the measures below,

Test Measure = 
var a= MAXX(all(DateTable),DateTable[Future 8 fridays])
var b=a-6
var c=CALCULATE(SUM('Combined Data'[Funding]),'Combined Data'[Approval Date - Forecast]>=b && 'Combined Data'[Approval Date - Forecast]<=a)
return c

result ( in card visual)

If you want to put it into table visual, then use this measure

Measure = 
var _maxdate= MAXX(all(DateTable),DateTable[Future 8 fridays])
var _start =_maxdate-6
var _sum=CALCULATE(SUM('Combined Data'[Funding]),'Combined Data'[Approval Date - Forecast]>=_start && 'Combined Data'[Approval Date - Forecast]<=_maxdate)
return IF(MIN(DateTable[Future 8 fridays])= _maxdate, _sum)

result

 

Best Regards,

Community Support Team _Tang

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

dhruvinushah's avatar
dhruvinushah
Responsive Resident
4 years ago

Hi,  v-xiaotang  In the table visual I believe they want to see the sum for each of those [Future 8 Fridays] values. 

So if the sum from 5/21 -5/27 was 10000$ , then they probably want to see that value next to that date. ðŸ˜…