cancel
Showing results for
Did you mean:
Frequent Visitor

## Variable in calculate Function

Hi everybody,

I'm a new user of Power BI and would like tu use variables in functions but i don't understand how it works.

I would like to use this function :

Part Privé N =
CALCULATE(

SUM([Solde]);[Exercice]=30/06/2016)

I would like to replace '30/06/2016' by a variable in order to change it easily.

Also, Il would like to use this same variable for other functions.

Thank you

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Variable in calculate Function

@Jcho10

You can use variables as following formulas. Here [Latest_Exercice] is a measure which always returns the latest date. You can also use other measures which returns a value.

This is just a sample and we need to adjust the formulas according to the actual requirement.

Measure 1:

`Latest_Exercice = MAX ( Table1[Exercice] )`

Measure 2:

```Part Privé N =
VAR Exercice = [Latest_Exercice]
RETURN
( CALCULATE ( SUM ( [Solde] ), Table1[Exercice] = Exercice ) )```

Best Regards,

Herbert

2 REPLIES 2
Super Contributor

## Re: Variable in calculate Function

@Jcho10

You can use variables as following formulas. Here [Latest_Exercice] is a measure which always returns the latest date. You can also use other measures which returns a value.

This is just a sample and we need to adjust the formulas according to the actual requirement.

Measure 1:

`Latest_Exercice = MAX ( Table1[Exercice] )`

Measure 2:

```Part Privé N =
VAR Exercice = [Latest_Exercice]
RETURN
( CALCULATE ( SUM ( [Solde] ), Table1[Exercice] = Exercice ) )```

Best Regards,

Herbert

Frequent Visitor

## Re: Variable in calculate Function

HI?

Thank you for your solution. It works well !

Sincerely