Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Running Total Removing Blanks

Hi Everyone, could use some help. I have a DAX caluclation issue in Power BI. I have a date and sales table joined via a one-to-many relationship on the 'date' column.   I want to calulate a run...
Need Help
Tips and Tricks
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

To your visual, ensure that you drag the Date column from the Date table.  Write this measure:

Current Running Total Measure =calculate([Sales],datesmtd(calendar[date]))

Hope this helps.