Forum Discussion

harshagraj's avatar
harshagraj
Icon for Post Partisan rankPost Partisan
2 years ago

Day,Hour,Minutes and additional parameters

Hello all i have a below data. Items Value DateTime Single-Top 0.0340069 3/7/2024 2:28 Single-Top 0.0340069 3/7/2024 4:10 Single-Top 0.0340069 3/7/2024 8:07 Double Top 0.5 3...
Need Help
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, harshagraj 

in power query make a three  custome columns and use below code
for day

Date.Day([date])

 

for hour
Time.Hour([date])

for minute

Time.Minute([date])

 

 

or add below code in your advance editor

 

 #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Date.Day([date])),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom.1", each Time.Hour([date])),
    #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Custom.2", each Time.Minute([date]))

 

 

 

  • harshagraj's avatar
    harshagraj
    Icon for Post Partisan rankPost Partisan
    2 years ago

    Hi Dangar332 thanks a lot for your response but i need a parameter or a slicer to be used to represent that datetime in day,hour,minute etc like this. 

     

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      hi, harshagraj 

       

      in power bi desktop go to modelling tab > new parameter >select field> drag and drop column of day,minute,hour(which we make in power query) > and select create

       

      here column name is different from you 

       

      field parameter interface look like below

       

       

      refer ARTICLE for more about Field parameter

       

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