Forum Discussion

Nimai123's avatar
Nimai123
Post Patron
6 years ago

Excel to DAX

I have a formula in excel which is calculating the percentage only if it has data for above 4 qtr   How can I convert this in a DAX expression using this logic of the formula   Reference image 1 ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Nimai123 , Take rolling of Qtr

Rolling 4 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD(Table[Date],ENDOFMONTH(Sales[Sales Date]),-4,QUARTER))

 

HAs full QTR= CALCULATE(distinctcount(Date[Date),DATESINPERIOD(Table[Date],ENDOFMONTH(Sales[Sales Date]),-4,QUARTER))

 

Final Rolling 4  =  if([HAs full QTR]=4,[Rolling 4 ],blank())