topic Time function in DAX Commands and Tips

Time function

Anonymous — Tue, 08 Jun 2021 16:15:27 GMT

Hello to all,

I am writing to you regarding a DAX request:

I have a table calculating the average electricity production according to a chosen period. This table is synchronized with two segments (Years and months) that allow me to choose the period I want to analyze.
What I would like to do is to add a column to this table that would calculate the average production of the current year (Year N). This would allow me to compare in the same table the values of previous years with the values of the current year.
The problem is that my segments take over my DAX query even when using an ALL function. Here is my query:

Moyenne corrigée année N (MWh) =

"AVERAGEX(

SUMMARIZE(

VALUES(Dates[Année]),

Dates[Année],

"E prod",

CALCULATE(SUM(fact_production[Energie produite (kWh)])/1000,fact_production[est_representatif]=TRUE(),YEAR(Dates[Année])=YEAR(TODAY()))

[E prod]

As you can see below, I did not select the year 2021 so no result is displayed

If it helps, I have a relationship between a column in my date table and a column in my production table where the electricity production values are:

Thanks in advance for your help,

Have a nice day

Joël

Re: Time function

PaulOlding — Tue, 08 Jun 2021 16:41:40 GMT

Is Moyenne corrigée periode (MWh) a measure that calculates what you want but for the selected time period instead of this year?

If so, does this work (where 'Year Column' is whatever you've used in the Periode prise en compte slicer) ?

Moyenne corrigée année N (MWh) =

CALCULATE(

[Moyenne corrigée periode (MWh)],

Dates[Year Column]=YEAR(TODAY())

)

Re: Time function

Anonymous — Wed, 09 Jun 2021 08:28:39 GMT

Hello

Indeed it works, thank you very much PaulOlding ! Sometimes you don't have to look too hard! ahahah

Have a nice day and thanks again

Bye