Forum Discussion

GeorgeVepkhvadz's avatar
GeorgeVepkhvadz
Icon for Helper I rankHelper I
2 years ago
Solved

Resources Exceeded - Running Total on Datediff calculated column

I am struggling with creating a measure which will do a running total based on calculated column which is datediff between two dates, Acquisiton date and transaction date. I need a visual to show ...
Need Help
  • GeorgeVepkhvadz's avatar
    GeorgeVepkhvadz
    2 years ago

    I am using import mode, but after lot of struggle I finally managed to do it.

    Way I did it, I created new dimension with only month numbers and made relationship between it and datediff, and then calculated running total using newly created dimension. 

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
2 years ago

Hey GeorgeVepkhvadz ,

 

consider creating a pbix file that contains sample data (of course, not 100s of millions of rows) but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or Dropbox and share the link). If you are importing the sample data from a spreadsheet isntead of using the manual input method share the spreadsheet as well.

 

Describe the expected result based on the sample data you provided.

 

Provide some of the measures you tried even if the did not work.

 

I'm also wondering if you are using direct query mode or import mode?

 

Regards,

Tom