Forum Discussion
Solved
DAX measure using dates uses too much memory
Hi, I'm fairly new to Power BI and have found so much help on this site thank you! I have a matrix visual that works fine in Desktop view, but exceeds memory usage when I publish it to app.pow...
Thefae
Can you try this version please:Omsætning kampagneperiode = var __Startdato = MIN ( 'kampagnemaal'[Startdato] ) var __Slutdato = MIN ( 'kampagnemaal'[Slutdato] ) return CALCULATE ( SUM ( 'fact Værdiposter (Value Entry)'[Sales Amount (Actual)] ), FILTER ( all('Date'), 'Date'[Date] > __Startdato && 'Date'[Date] < __Slutdato ) )
