Forum Discussion

pdovala's avatar
pdovala
New Member
4 years ago
Solved

Sum column values based on todays date or today()

Hi Need help please, i have a table with dates as columns and planned values in rows and want to add row values based on today(), can i please get help how to get that measure in DAX.
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi pdovala 

     

    You're not going to be able to accomplish what you need with your data like that.  I'd suggest modifying the table structure in Power Query to unpivot the dates so your table instead has two fields: Date and Value/Amount.  Once you do that, this should be pretty easy.

    CALCULATE(
	SUM([Value/Amount]),
	[Date] = TODAY()
)

    Hope this helps!

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
4 years ago

Hi pdovala 

 

You're not going to be able to accomplish what you need with your data like that.  I'd suggest modifying the table structure in Power Query to unpivot the dates so your table instead has two fields: Date and Value/Amount.  Once you do that, this should be pretty easy.

CALCULATE(
	SUM([Value/Amount]),
	[Date] = TODAY()
)

Hope this helps!