topic Weekday as DAX measure and not as calculated column in DAX Commands and Tips

Weekday as DAX measure and not as calculated column

HarishRathore25 — Sat, 23 May 2020 06:48:40 GMT

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

Re: Weekday as DAX measure and not as calculated column

AlB — Sat, 23 May 2020 08:12:10 GMT

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

Re: Weekday as DAX measure and not as calculated column

HarishRathore25 — Sat, 23 May 2020 08:28:02 GMT

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

Re: Weekday as DAX measure and not as calculated column

AlB — Sat, 23 May 2020 09:20:55 GMT

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

Re: Weekday as DAX measure and not as calculated column

HarishRathore25 — Sat, 23 May 2020 12:19:45 GMT

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

Regards

Harish Rathore