Weekday as DAX measure and not as calculated column

[HarishRathore25]

Hi,

I have a fact table and a calendar table with date. I need to show weekday name (for e.g. 1st Jan is Monday) as DAX measure in pivot table and not a calculated column in calendar table.

I have tried using FORMAT function, its working fine when i use it in calendar table but i need weekday as measure because i have already put "Date" in rows in pivot table.

Please help.

Regards

Harish Rathore

[AlB]

Hi @HarishRathore25 

If you already have DateTable[Date] in your "pivot table" you can just use:

DayNameMeasure= SELECTEDVALUE( DateTable[DayName] )

where DayName is the name of the column in your DateTable that has the name of the day.

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers 

[HarishRathore25]

Hi @AlB , thanks for your quick response. But i would like to inform you that i do not get any function called "SELECTEDVALUE" in my office 365 version. I am working on powerpivot model in excel. Any other method which can resolve my issue?

Regards

Harish

[AlB · Accepted solution]

DayNameMeasure = IF ( HASONEVALUE ( DateTable[DayName] ), VALUES ( DateTable[DayName] ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers 

[HarishRathore25]

Thanks a ton @AlB ..... that worked like a charm.

Regards

Harish Rathore