DatesBetween Problem

M

m_aatif

Board Regular
Joined
Apr 18, 2013
Messages
56
While throwing measure calculated by datesbetween on Pivot Table, I get following error.

"Invalid Numeric representation of a dateValue was encountered"

Please explain & Help.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

B
  • Question Question
slicer for selection of different date tables
Replies
1
Views
250
Matt Allington
M
W
  • Question Question
DAX - CALCULATE and SUMX
Replies
4
Views
452
Wishmaster89
W
L
  • Solved
DAX: Double or Nested COUNTX() & SUMX()
Replies
6
Views
532
luuk
L
R
  • Question Question
Filter is not applied to a measure in the detail table
Replies
1
Views
138
sanalytics
S
M
  • Question Question
Calculate the time difference
Replies
1
Views
489
Matt Allington
M

Forum statistics

Threads
1,224,154
Messages
6,176,731
Members
452,740
Latest member
MrCY

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