Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
fabiomanniti
Helper III
Helper III

DAX measure with dynamic input

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

4 REPLIES 4
SanketBhagwat
Solution Sage
Solution Sage

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

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.

Anonymous
Not applicable

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

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.