Forum Discussion

changhongchoo's avatar
changhongchoo
Frequent Visitor
5 years ago
Solved

Current & Previous Month Difference Combine within 13 months period

Hi,    I wanted to calculate the difference between current month and last month, and only show the 13 months trend. The current month can be selected by a slicer. These are my working steps: ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi changhongchoo ,

     

    From this:

    Assume my slicer value is now "Jul-21", I want to show the result from "Jul-20" to "Jul-21" only. 

     

    I think you want to display the value of last 13 month not the total difference of the last 13 month,right?

    If so , please create a flag measure and apply it to visual-filter pane, set as "=1":

     

    Flag = 
var _sele=MAX('Date(for slicer)'[Date].[Date])
var _datediff=DATEDIFF(MAX('Table'[Date]),_sele,MONTH)
return IF( _datediff>=0 && _datediff<13,1,0)

     

     

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi changhongchoo ,

 

From this:

Assume my slicer value is now "Jul-21", I want to show the result from "Jul-20" to "Jul-21" only. 

 

I think you want to display the value of last 13 month not the total difference of the last 13 month,right?

If so , please create a flag measure and apply it to visual-filter pane, set as "=1":

 

Flag = 
var _sele=MAX('Date(for slicer)'[Date].[Date])
var _datediff=DATEDIFF(MAX('Table'[Date]),_sele,MONTH)
return IF( _datediff>=0 && _datediff<13,1,0)

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.