Forum Discussion
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 does...
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] &"")
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.