Forum Discussion

NickzNickz's avatar
NickzNickz
Icon for Helper IV rankHelper IV
3 years ago
Solved

Greeting User Login Message

Hi ...    I have below measures to greet users who access the dashboard.  Greeting User = VAR _User = USERNAME() VAR _Hour = HOUR(NOW()) VAR _Prefix = SWITCH( TRUE(), _Hour <...
DAX
  • tackytechtom's avatar
    tackytechtom
    3 years ago

    Hi NickzNickz ,


    What a great idea to greet your users! 

     

    How about this:

    Measure = 
VAR _User = USERNAME()
VAR _Hour = HOUR(NOW())
VAR _Prefix =
    SWITCH(
        TRUE(),
        _Hour < 12, "Good Morning ",
        _Hour >= 12 && _Hour < 17, "Good Afternoon ",
        "Good Evening "
    )

RETURN
CONCATENATE(_Prefix, SUBSTITUTE(_User, "DOMAIN\", "") )

     

    Let me know if this helps 🙂

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/

tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Hi NickzNickz ,


What a great idea to greet your users! 

 

How about this:

Measure = 
VAR _User = USERNAME()
VAR _Hour = HOUR(NOW())
VAR _Prefix =
    SWITCH(
        TRUE(),
        _Hour < 12, "Good Morning ",
        _Hour >= 12 && _Hour < 17, "Good Afternoon ",
        "Good Evening "
    )

RETURN
CONCATENATE(_Prefix, SUBSTITUTE(_User, "DOMAIN\", "") )

 

Let me know if this helps 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

NickzNickz's avatar
NickzNickz
Icon for Helper IV rankHelper IV
3 years ago

Hi tackytechtom ,

 

I have tested and it shows me the name without the domain name..Greatttt!!!. 
I need to replace DOMAIN\ with my domain name ...😅
If I publish it at power bi service, how can I ensure the timezone follows my timezone ... 

 

Really appreciate your help tackytechtom  ...

 

Regards,

NickzNickz