cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reigning_data Frequent Visitor
Frequent Visitor

Create a variable to act as a filter within calculate

Hi All,

 

Apologies if this has been answered before, I have tried to google it but I'm not sure how to pose the question.

 

My issue is this:

 

Say I have several measures that need to do the same thing, on different data sources.

 

Example would be

Revenue = CALCULATE ( SUM ( column1 ) ,

DATESBETWEEN ( calendar , DATE ( 2019,01,01 ) , DATE ( 2019,02,01 )

))

 

What I would like to do is to create the DATESBETWEEN filter as it's own variable, seperate from the measure so that, in the eventuality that the DATESBETWEEN period needs changing, I would only need to change it once, not for every measure. Something like below is what I had in mind.

 

Period = DATESBETWEEN ( calendar , DATE ( 2019,01,01 ) , DATE ( 2019,02,01 ) )

Revenue = CALCULATE( SUM ( column1 ) , [Period] )

 

Many thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Create a variable to act as a filter within calculate

Hi @Reigning_data 

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Create a variable to act as a filter within calculate

Hi @Reigning_data 

 

Regards,

Owen



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!