Forum Discussion

StenX's avatar
StenX
Frequent Visitor
4 years ago
Solved

Using DATEADD() and cross-filtering

Hi All !  we have 2 simple datasets + Calendar:   our screen:     Our steps:   1. choice Products in slicer Prod or leave it unselected 2. choice month in slicer Month (one or mo...
Need Help
  • StenX's avatar
    StenX
    4 years ago

    I was modify my formula (using PARALLELPERIOD ) and it worked!

     

    Nprev = 
VAR monthBack = (DATEDIFF(MIN('rsp'[date]),MAX('rsp'[date]),MONTH)+1)*-1
VAR xStart = STARTOFMONTH(PARALLELPERIOD(rsp[date],monthBack,MONTH))
VAR xEnd = ENDOFMONTH(PARALLELPERIOD(rsp[date],monthBack,MONTH))
VAR cntx = CALCULATE(COUNTROWS(txt),FILTER(ALL(rsp[date],rsp[month]),rsp[date]>=xStart && rsp[date]<=xEnd))

RETURN cntx
amitchandak's avatar
amitchandak
Super User
4 years ago

StenX , Try like

 

same period based on date range
Last Period =
var _max =maxx(date,date[date])
var _min =maxx(date,date[date])
var datediff1 = datediff(_min,_max,day)
var _maxX = _max-datediff1
var _minX = _min -datediff1
return
CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date]<=_maxX &&date[date]>=_minX)))