Forum Discussion

Thefae's avatar
Thefae
Frequent Visitor
5 years ago
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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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 
    )
)



Fowmy's avatar
Fowmy
Super User
5 years ago

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 
    )
)



  • Thefae's avatar
    Thefae
    Frequent Visitor
    5 years ago

    That worked perfectly, thank you!