Help with DAX

[Guttmann1983]

[FONT=&quot]Hi, I am trying to figure out where I am going wrong with the below DAX Expression [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]=IF(AND(YEAR([Demand Sent]=YEAR(TODAY())),WEEKNUM([Demand Sent]=WEEKNUM(TODAY())),FORMAT([Demand Sent],"ddd"),""))[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot][Demand Sent] is a field that is either a date, or is blank. I am trying to get the dax expression to return "Mon" or "Tue" or "Wed" etc. if the date in this field is from the current week (Monday - Sunday) or return blank if its not. the last peice, FORMAT([Demand Sent],"ddd"),"")) is giving me problems.[/FONT]

 

[Nick Chobotar]

Guttmann1983

It appears parenthesis were left open in the first parameter of YEAR & WEEKNUM functions.

=
IF (
AND (
YEAR ( [Demand Sent] ) = YEAR ( TODAY () ),
WEEKNUM ( [Demand Sent] ) = WEEKNUM ( TODAY () )
),
FORMAT ( [Demand Sent], "ddd" ),
""
)

Here is the result I got in calc column:

<table verdana,="" arial,="" tahoma,="" calibri,="" geneva,="" sans-serif;"="" width=""><tbody>[TR]
[TH]Demand Sent[/TH]
[TH]Calculated Column 1[/TH]
[/TR]
[TR]
[TD]11/12/2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11/24/2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/6/2016[/TD]
[TD]Tue[/TD]
[/TR]
[TR]
[TD]12/18/2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12/30/2016[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/11/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/23/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/4/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/16/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/28/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3/12/2017[/TD]
[TD][/TD]
[/TR]
</tbody></table>


Thanks, Nick -

 

[Nick Chobotar]

Sorry for the HTML tags ...

Here is the result I got:

Demand Sent Calculated Column 1
11/12/2016
11/24/2016
12/6/2016 Tue
12/18/2016
12/30/2016
1/11/2017
1/23/2017
2/4/2017
2/16/2017
2/28/2017
3/12/2017

 

[Guttmann1983]

when I use the below


=
IF (
AND (
YEAR ( [Demand Sent] ) = YEAR ( TODAY () ),
WEEKNUM ( [Demand Sent] ) = WEEKNUM ( TODAY () )
),
FORMAT ( [Demand Sent], "ddd" ),
""
)

the "ddd" and "" from the part "ddd" ), "") are in red

 

[Nick Chobotar]

Guttmann1983,

Hmmm! Are you trying this code as a calculated column not as a measure?