Forum Discussion

Twister8's avatar
Twister8
Icon for Helper II rankHelper II
9 years ago
Solved

Show total only last month

Hi,   I need help   I need show in my gauge the value just of the LASTMONTH   When I use the expression:   = CALCULATE([VALUE];DATEADD(Tempo[Date]; -1; MONTH))   My result its total, its su...
  • Twister8's avatar
    Twister8
    9 years ago

    HI,

     

    Tks everybody for answers...

     

    I solved:

    Column

    LastMonth = IF(YEAR(TODAY())= YEAR('Fact'[Date]) && MONTH(TODAY())-1 = MONTH('Fact'[Date]);1;BLANK())

     

    Measure

    Mymeasure = CALCULATE(SUM('Fact'[Value]);'Fact'[LatMonth] =1)

  • Twister8's avatar
    Twister8
    Icon for Helper II rankHelper II
    9 years ago

    Tks for answer :)

     

    But i have a error:

     

    A3 = IF(MONTH(LASTDATE(ALL('Fct'[DATA]))) = Time[Date]
    && YEAR(LASTDATE(ALL('Fct'[DATA]))) = Time[Date];"Y";"N")

     

    Could not determine a single value for the 'Date' column in the 'Time' table. This can happen when a measure formula refers to a column containing many values, without specifying an aggregation, such as min, max, Cont or sound for a single result.