If logical test return value from another column

[RezkinGaland]

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.

[amitchandak]

@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]

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.