Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Sum for most recent date available

I have a table that records sales by date. I need to be able to display the total sales for each date and also display the prior date's total. What is a measure in dax that I can use to sum based on ...
"Dates"
"DAX help"
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

Thanks for smpa01 reply. Have you resolved your issue now, happy to help, have you checked that your data types are as expected, or can you share the pbix file with no sensitive data so it's quicker to determine why your data is not showing up.


Best Regards,
Yang
Community Support Team



Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi though this solution did not work for me I was able to resolve on my own.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    Glad you solved the problem, if you don't mind could you attach your solution so that someone with a similar problem can find the solution, thanks in advance!

    Best Regards,
    Yang
    Community Support Team