Forum Discussion

Twister8's avatar
Twister8
Helper 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)

sprather's avatar
sprather
Frequent Visitor
9 years ago

I just create a calculated column on the date field in the table:

 

IsPreviousMonthIns = IF(Month([Inspection_Date])=Month(Today())-1,"YES","NO")

 

Then set a visual level filter on this column to filter out the "No" results.

 

I also create a column to check current year:

 

IsCurrentYearIns = IF(Year([Inspection_Date])=Year(Today()),"YES","NO")

 

These two columns allow me to pull only last months results for the current year......Works nicely....