Forum Discussion

thampton's avatar
thampton
Icon for Helper III rankHelper III
7 years ago
Solved

Help writing DAX measure

I have a table with the format below . I need to be able to create a measure that calculates the sum of the values based on the corresponding date (month to date ONLY). For instance, today's value wo...
Need Help
Show and Tell
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    thampton,

     

    You may try DAX function TOTALMTD, create a measure and use DAX formula below:

    Result =
TOTALMTD ( SUM ( Table[Value] ), Table[Date] )

    Community Support Team _ Jimmy Tao

    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
7 years ago

ok, i see now, and do  you want it to work with real time? or simply add the days before the date selected?? 

thampton's avatar
thampton
Icon for Helper III rankHelper III
7 years ago

Anonymous Yes, updating real time would be perfect. I dont plan on using slicer to control date. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I am not that strong with date formating and code, sorry on that respect , 

    but I would suggest looking through this website here that has all the dax commands that can be used in power BI, spesificaly heres a link to the date and time section

     

    https://docs.microsoft.com/en-us/dax/date-and-time-functions-dax

     

    sorry I could not be of more help.

     

    best regards,

    Collin