Forum Discussion

askspepsi's avatar
askspepsi
Helper II
6 years ago
Solved

Extract AM / PM from Datetime format in direct query

hi all,   Greetings,   Is the way to Extract AM or PM from Datetime format in direct query without changing to Import storage. Or is there any another way to create another table or colume to ex...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi askspepsi , 

    You could try to refer to Greg_Deckler 's measure, and change it  and apply this in table visual like below

    Measure = IF(RIGHT(MAX('Table1'[date]) & "",2)=SELECTEDVALUE('Table'[time]), 1,0)

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

askspepsi's avatar
askspepsi
Helper II
6 years ago

Greg_Deckler  thanks for the update.

 

iam really sorry i was not clear in the question i asked, let me rephrase again.

 

i have column name with datetime (see the below) and create AM / PM when i select AM the 06:00 and 5:50 only and when i select PM i what 17:58 and 17:59 

2020-07-23 17:58:57.000
2020-07-23 17:59:02.000
2020-07-23 06:00:37.000
2020-07-23 05:50:25.000
dax's avatar
dax
Community Support
6 years ago

Hi askspepsi , 

You could try to refer to Greg_Deckler 's measure, and change it  and apply this in table visual like below

Measure = IF(RIGHT(MAX('Table1'[date]) & "",2)=SELECTEDVALUE('Table'[time]), 1,0)

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.