+ Reply to Thread
Results 1 to 3 of 3

DAX access value in another table rules

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    611

    DAX access value in another table rules

    Hi,

    I built a two column table using 'enter data' , two columns two dates, I then used add columns to add a column


    Please Login or Register  to view this content.
    to get year,

    But when I tried to use these dates to build a calendar I had to wrap in Min or Max, there was only one so didn't matter,


    Please Login or Register  to view this content.
    My question regards why in the fist example , add column, I could use YEAR directly but in the second I had to use the MIN first,
    I don't really know what question I need to be asking in order to find the answer, if anyone has an answer or directions to a post on this
    I'd be grateful.

    RD

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: DAX access value in another table rules

    In the first one there is row context - i.e. the calculation is done for each row (the fact that there only happens to be one row is irrelevant).

    In your measure there is no row context and you want one value but 'EnterData'[Enddate] refers to the entire table column, hence you need MIN and MAX.
    Rory

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    611

    Re: DAX access value in another table rules

    Thank you, on refection that makes perfect sense,
    I'd give you a rating but it won't let me,
    RD

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Validation rules for ms access
    By helponmacro in forum Access Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2017, 08:13 PM
  2. Replies: 0
    Last Post: 06-13-2017, 10:23 AM
  3. Replies: 1
    Last Post: 12-02-2014, 05:46 AM
  4. Use an Excel Macro in Access VBA - Import text file in Access Table
    By joogibabu in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-08-2014, 10:04 AM
  5. [SOLVED] Permission to access forum rules
    By JOHN H. DAVIS in forum Suggestions for Improvement
    Replies: 23
    Last Post: 06-21-2013, 04:58 AM
  6. Access VBA or SQL to find and delete duplicate records in access table
    By ewong in forum Access Programming / VBA / Macros
    Replies: 10
    Last Post: 09-14-2012, 06:55 PM
  7. Importing data from Access to Excel, but I need to vary the table from Access
    By Liz L. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-05-2006, 09:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1