Forum Discussion

RezkinGaland's avatar
RezkinGaland
New Member
4 years ago

If logical test return value from another column

Hello everyone,

 

I'm very new to Dax and powerBI so working my way around it.

 

Presently I'm trying to show the data in another column based on todays date.

 

The below DAX xommand which doesn't work:

PeriodNumber test = IF(Mars_Calendar[CalendarDate] = TODAY(), (Mars_Calendar[Period]))

 

I'm sure I'm missing something pretty basic but any help would be apperciated.

 

KR,

Rob.

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    RezkinGaland  Not clear what are you trying here.  Can you share sample data and sample output in table format?

     

    example

    Is Today = if(Mars_Calendar[CalendarDate] =TODAY(),"Today",Mars_Calendar[CalendarDate] &"")

    • RezkinGaland's avatar
      RezkinGaland
      New Member
      4 years ago

      Thank you for your response.

       

      CalendarDate is a column that dynamically keeps to todays date. What I then want to do is based on todays date in calendar date, show the correspondingcontents in the field 'PeriodNum'. 

       

      So if 'CalendarDate' = TODAY(), show the 'PeriodNum' data.

       

       

      Hopefully that makes sense.