Forum Discussion
Daily Progress Transfer to other Table
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
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.
2 Replies
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.Thank you very much
