cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jcho10 Frequent Visitor
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.

 

Could you please help me ?

 

Thank you

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-haibl-msft Super Contributor
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
v-haibl-msft Super Contributor
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

Jcho10 Frequent Visitor
Frequent Visitor

Re: Variable in calculate Function

HI?

 

Thank you for your solution. It works well !

 

Sincerely