Forum Discussion

ArsalanFND's avatar
ArsalanFND
Frequent Visitor
7 years ago

Running into Memory Issue

Hello People!   I will be brief and straight to the point.   i have a dataset as follows:   Date_Time                        Entry  Exit  (entry - Exit)  12/21/2016 12:00:00 AM    5       4   ...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI ArsalanFND,

 

Nope, it seems like your intervals split your records to too many sub-records which need to calculate and progress in memory.

 

I can only suggest you use 64 bit power bi desktop with large physical memory or prepare a detail table with detailed interval records to reduce calculate pressure.

 

In addition, you can also take a look at following link if your requirement is similar as below:

DAX - 15 minute Interval Question

 

Regards,

Xiaoxin Sheng

  • ArsalanFND's avatar
    ArsalanFND
    Frequent Visitor
    7 years ago

    Hi Xiaoxin,

     

    Thanks for the reply, yes correct the sun-records are too many. 

     

    The link you provide was helpful but i am ok with that part.

     

    I am calculationg the Running Total based on my Date Time Table which as 3 years each day with 96 intervals. Which is a huge calculation every time. 

     

    Is there a way i can calculate it and save it so it's not calculated every time?

     

    Thanks,

    FND

  • ArsalanFND's avatar
    ArsalanFND
    Frequent Visitor
    7 years ago

    Hi,

     

    Also i able to create the measure with Running total. How can i calculate MAX for the day? for visuals.

     

    Running total is measure and DateTime is a column from another table with realtionship.

     

    Thansk,

     

    Cheers,

    • ArsalanFND's avatar
      ArsalanFND
      Frequent Visitor
      7 years ago

      So I got the Max values. NOw my only issue is still i am unable to visualize MAX for the day. should i use SQL databse instead of Excel files to load and process m data faster??

       

      Thanks,

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        HI ArsalanFND,

         

        I'd like to suggest you create a table to store expand records, then you only need to do summarize on real records. In my opinion, it will spend less system resource than calculate with huge virtual table.

         

        Regards,

        Xiaoxin Sheng