Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

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 Da...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
2 years ago

Thank you very much