Calculate target by period

[eraldo_DP]

Hi Everyone,

How i can calculate the target corresponding to the date and group?

https://1drv.ms/u/s!As-s3TNexQ8TipkPATGyYTW6Fbr-qA?e=gLg3Ev  

 

[sturlaws]

Hi @eraldo_DP 

I would create a Group table, and join both Sales and Target to this table. Also, change the Group values in Target from type group_1 to group1.

Cheers,
Sturla

[eraldo_DP]

Thanks Sturla,

Sorry. I did writed wrong the name group. But this new file is correct.

In my enviroment i create one table with Groups, and related with others tables.

I did try resolve with function "DatesBetween", but no sucess.

CALCULATE(MAXX(Target,Target[Target Conversation]),

DATESBETWEEN(dCalendar[Date],

LASTDATE(Target[StartDate]),

MAX(Target[EndDate]) )

https://1drv.ms/u/s!As-s3TNexQ8TipkPATGyYTW6Fbr-qA?e=QrXwfd 

)

I'm sorry for my english, i need improve.

[eraldo_DP · Accepted solution]

The solution is here https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-target-by-data/m-p/1186637/t...