Forum Discussion

VazhaPBI's avatar
VazhaPBI
Frequent Visitor
3 years ago
Solved

Daily Sales Plan Total By Filtered Date

Hello Guys, I divided Monthly Sales Budget by monthly working days, but now total doesnt show sum of i, now my situation is seen on screen. this is Daily budget calculation: Daily Budget2 =...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi VazhaPBI ,

     

     I think you can create sum based on [Daily Budget2] table.

    New Daily Budget2 =
SUMX ( VALUES ( 'TableName'[Date] ), [Daily Budget2] )

     

    Best Regards,
    Rico 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
3 years ago

Hi VazhaPBI ,

 

 I think you can create sum based on [Daily Budget2] table.

New Daily Budget2 =
SUMX ( VALUES ( 'TableName'[Date] ), [Daily Budget2] )

 

Best Regards,
Rico Zhou

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