Monthly consumption

[msae26]

Hi guys

I really need your help. I have a view with accumulatives per day of water, vapor of water and gas consumption. Base on that information I calcualted the effiency ("Rendimento ET mensile" column), until here all right. But I need a view where I can get the monthly effiency base on the monthly accumulative.

Something like this:

Data	ore_marcia_mensile	mensile_consumo_COGE_Acqua_calda_MWht	mensile_consumo_ET_COGE_Vapore_MWth	mensile_consumo_GN_COGE_Smc	Rendimento ET mensile
01-2022	470	260	218	142249	34,56%
02-2022	636	353	310	192460	35,45%
03-2022	501	310	238	152314	35,99%
04-2022	72	46	32	22056	34,42%

Thanks in advance to all who reply.

[v-cazheng-msft]

Hi @msae26,

May I know whether you still have problems? If I misunderstand your needs, please feel free to let me know. Thanks in advance!

Best Regards,

Community Support Team _ Caiyun

[v-cazheng-msft · Accepted solution]

Hi @msae26,

Firstly, you need create a new column with Calculated column.

Month-Year =
VAR month_ =
    MONTH ( 'Table'[Data] )
VAR year_ =
    YEAR ( 'Table'[Data] )
RETURN
    IF ( month_ < 10, "0" & month_ & "-" & year_, month_ & "-" & year_ )

Then, you need create Measures for the fields you would like to add into the new visual. For example, you can get the desired value from ore_macia_mensile by using the following Measure.

ore_macia_mensile__ =
VAR maxDate =
    CALCULATE ( MAX ( 'Table'[Data] ), VALUES ( 'Table'[Month-Year] ) )
RETURN
    CALCULATE (
        'Table'[Ore__Marcia__Mensile],
        FILTER ( 'Table', 'Table'[Data] = maxDate )
    )

Then, the result looks like this.

To get other values, you just need make some changes to this Measure.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[daXtreme]

Is it not enough to create a table in the model that would pull out of the cumulative view only the data for the last day of each month?

[msae26]

HI daXtreme

What more do i need to ?