O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Calculating today's date using the MemberValue function

The second way to calculate today's date is by using the MemberValue() function. This is something we've already used in the Finding the last date with data recipe. In case you haven't read it yet, do so before continuing with this recipe, at least the part that shows the ValueColumn property.

Getting ready

Open SQL Server Data Tools (SSDT) and then open theAdventure Works DW 2016 solution. Double-click on the Date dimension found in the Solution Explorer. Select the Date attribute and locate the ValueColumn property. It should not be empty; otherwise this recipe won't work. It should have the Date type column from the underlying time dimension table.

How to do it...

Follow these steps to calculate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required