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 ,

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.