DATEADD not working

didijaba

didijaba

Well-known Member
Joined
Nov 26, 2006
Messages
511
HI, I have formula I want to use but it doesn't give me wanted day shift. Masure "Count Of Selected Calendar Days" shows correct amount of days, but when applied within formula it shifts days just for 1 day, not 15, for example). Please advice, thanks
Code: 
CashIn Previous Period = 

CALCULATE([CashIn],DATEADD('Calendar'[Date],[Count Of Selected Calendar Days]),DAY))
 
Last edited:

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

brendalpzm
  • Question Question
Gallery not filtering properly
Replies
0
Views
216
brendalpzm
brendalpzm
brendalpzm
  • Question Question
Power Apps formula in gallery to apply condition
Replies
4
Views
325
brendalpzm
brendalpzm
M
  • Solved
Calculating Same Day Last Week only works partially in Power BI
Replies
2
Views
509
muhammadahmad21
M
P
  • Question Question
DAX PIVOT: Projects Closure Date Field - Number of Days Change - between differing Forecast Versions
Replies
0
Views
395
phil134
P
M
  • Question Question
DATEADD 'dates must be contiguous' error referencing measure in SWITCH formula
Replies
0
Views
2K
Maccer
M

Forum statistics

Threads
1,223,948
Messages
6,175,569
Members
452,652
Latest member
eduedu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top