Forum Discussion

jlf81's avatar
jlf81
Frequent Visitor
5 years ago

Current vs Previous based on relative filter

Is there anyway to build a measure that would give you the current period vs the previous period, based on a relative filter.    For eaxmple if the filter is set to last 30 days it would show the l...
Need Help
jlf81's avatar
jlf81
Frequent Visitor
5 years ago

amitchandak Awesome, thank you.

 

Is there any way to edit that to deal with YTD\MTD? or would I need to adjust that measure

 

Little typo in you solution 'var _min =maxx(date,date[date])' should be 'var _min =minx(date,date[date])' shouldn't it? Also couldn't get that last bit to work, but replaced it with ,DATESBETWEEN('Dim Date'[Date],_minX,_maxX))) and that seems ok

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi jlf81,

    Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng