Daily Progress Transfer to other Table

[AllanBerces]

Hi good day, 

Can anyone pls need assistance I have 3 Table (Daily SQL, Dimdate and S-Curve). Daily SQL contain day to day daily progress. I want to get the daily progress on a certain project in Daily SQL table filtered by 4 column. Link below

https://drive.google.com/file/d/1A39_mHQI4BDYgNtRw2C7v_X7v8dpfeR5/view?usp=drivesdk 

Thank you

[Anonymous · Accepted solution]

Hi @AllanBerces ,

Regarding your question:
Use the following DAX expression to create a measure named ‘Daily Progress’

Daily Progress = 
       CALCULATE(SUM('Daily SQL'[Earned last 24 hrs]),SUMMARIZE('Daily SQL','Daily SQL'[WON],'Daily SQL'[Task Phase],'Daily SQL'[Main Cat]))

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

[AllanBerces]

Thank you very much