Need help with Measure

[Anonymous]

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 . please let me knw what went wrong.

Test Measure =

var a= MAXX(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

[v-xiaotang]

Hi  @Anonymous 

Thanks for reaching out to us. I need to confirm the questions in the picture below,

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]

Hi @v-xiaotang  , Yes i think so. They are trying to create a table visual to show the Week to date sum of the [Funding] field. And just show those WTD values for those Future 8 Fridays fiels as shown in the screenshot above.

[v-xiaotang]

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]

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

[Anonymous]

Hi,

Try this 

var a= selectedvalue(DateTable,DateTable[Future 8 fridays])

[Ashish_Mathur]

Hi,

Share the download link of your PBI file and show the expected result.

[dhruvinushah]

Hi @Anonymous ,

Your measure is working for the MAX date or the last date in the Future 8 Fridays field.