DAX measure with dynamic input

[fabiomanniti]

I am afraid the answer to this question is not but I'll try.

Is it possible to create a measure with a dynanic input from other measures?

For example:

function doubleIt(number){
    return number*2
}

function mySalesDoubled(){
   var mySales = Table[amount]
   var doubleSales = doubleIt(mySales)
   return doubleSales
} 

 So I make two measures, one is doubleIt and another is mySalesDoubled

[SanketBhagwat]

Hi @fabiomanniti .

If you want to have a dynamic value then why not directly write down the value rather than writing down the measure.

For example, IF([Measure]=100, "A","B")


Let me know if I have answered your question.
If yes, then kindly mark it as "Accept as Solution" and give it a thumbs up.

THanks,
Sanket

[fabiomanniti]

Well, but this is not very helpful because my main problem is that sometimes I have to write multiple times the same measure with just one variable as difference and I would like to write part of code as an external measure instead of copying it everytime.
I make an example:
I want to know the percentage of users I had one month ago, three months ago, six months ago, up to one year ago.

Then I want to put these four values into a table and see all the results.

In order to obtain this I write the same measure four times and anytime I change the number of months I must subtract from today's date. 
It would be helpful if I could use an external measure where I insert the number of months and I obtain the date of those number of months ago.

[v-yiruan-msft]

Hi @fabiomanniti ,

You can refer the following links to get it.

Previous Month's Count and 2 Months Before

sales 6 months ago

Try this measure

=calculate([qty_sales],datesbetween(calendario[date_key],EOMONTH(MAXX(ALL(calendario),calendario[date_key]),-6)+1),MAX(calendario[date_key])))

To your visual, drag Year and Month from the calendario table.  Ensure the actual date columns of your data table and calendario table are related.

Calculate the values ​​of the 1, 3 and 6 months prior to the current one

assuming you have date table and marked as date, you can use following measure to calculation L12 month and change this measure for 3 and 6 months

Last 12 Months = 
VAR __lastMonthDate = EOMONTH ( TODAY(), -1 )
VAR __numberofMonth = 12
RETURN
 CALCULATE (
    SUM ( Table[Sales] ) ,
    DATESINPERIOD (
        Calendar[Date],
        __lastMonthDate,
        -__numberofMonth,
        MONTH
    )
)​

Best Regards

[JeffAsh4916]

This was exactly what I had been searching for - I was needing to filter results 'on the fly' depending upon a user-selected week ending date. I ended up using DATESBETWEEN for the clustered column field and a different range of DATESBETWEEN for the associated line chart.