Forum Discussion

Gertjan's avatar
Gertjan
Frequent Visitor
4 years ago
Solved

DAX count consecutive days without stock

Hi there,  I have a calculated column that counts the number of consecutive days an item is out-of-stock. It works if there isn't that much data in the tables. However, when there is more data in th...
DAX tips
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Gertjan 

     

    Obviously, there is nothing wrong with your code and the code doesn't look like there's anything to simplify. Mainly because you have a large amount of data.

    For your case, I have these suggestions:

    • Filter the date column or other columns in PQ to control the amount of data obtained in the report each time.
    • Change the calculated column to measure, it will reduce memory calculation, but it needs to be created according to the context of the visual.
    • Change to a more advanced machine to create the report, you can try to change the setting first.

              

    If you are interested in the above suggestions but have problems, please add information, or share a sample file, and I will help you solve it.

     

    Did I answer your question? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

    Best Regards,
    Community Support Team _ Janey

     

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Gertjan 

 

Obviously, there is nothing wrong with your code and the code doesn't look like there's anything to simplify. Mainly because you have a large amount of data.

For your case, I have these suggestions:

  • Filter the date column or other columns in PQ to control the amount of data obtained in the report each time.
  • Change the calculated column to measure, it will reduce memory calculation, but it needs to be created according to the context of the visual.
  • Change to a more advanced machine to create the report, you can try to change the setting first.

          

If you are interested in the above suggestions but have problems, please add information, or share a sample file, and I will help you solve it.

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey