Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Fill a column based on last month date

Hello!   I need to create a calulated column "NEW COLUM", placing the last month values acording to the  "tipe" column,  and olny the last month f.e I had 2700000 kg of CPRS in January, i need the...
Need Help
Show and Tell
Tutorial Requests
  • LivioLanzo's avatar
    LivioLanzo
    7 years ago

    Try like this:

     

    = CALCULATE(

            SUM( 'Table'[kGS] ),

            ALLEXCEPT( 'Table', 'Table'[Type] ),

            'Table'[Month] = EARLIER( 'Table'[Month] ) - 1

    )

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
7 years ago

You'll need a date table to do this properly. Then the following measure will give you the previous month sales. The filter context of the table/matrix will keep it to just items of the same Type.

 

=CALCULATE(
	[Total Sales],
	PREVIOUSMONTH('Calendar'[Date])
)