Skip to content

Instantly share code, notes, and snippets.

@DmitriyVlasov

DmitriyVlasov/Added-date-and-hour-colum.dax

Last active May 21, 2019 11:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DmitriyVlasov/291ca99391d5f00cd3c5870a613f8476 to your computer and use it in GitHub Desktop.
Save DmitriyVlasov/291ca99391d5f00cd3c5870a613f8476 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Added-date-and-hour-colum.dax
// На большом объеме данных так работает плохо!!!
var date_time_text = format( 'fact_data'[moment]; "dd.MM.yyyy hh:00:00" )
var current_date = DATEVALUE( date_time_text )
var current_time = timeVALUE( date_time_text )
var curent_datetime = current_date + current_time
return curent_datetime
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment