Forum Discussion

fabiomanniti's avatar
fabiomanniti
Icon for Helper III rankHelper III
4 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
fabiomanniti
Icon for Helper III rankHelper III
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      JeffAsh4916
      New Member
      3 years ago

      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.