Tuesday, 22 October 2013

showing number of days between 2 dates

The example below shows two dates for each dimension member. Open date and close date. Suppose we also want to show the number of days between the two dates. Here's how this was achieved here. Define a computed measure that uses the base measures and use the DATEDIFF function to get the # of days.



Output.


.

No comments:

Post a Comment