Forum Discussion

Hann_Sen's avatar
Hann_Sen
Regular Visitor
2 years ago

Normalized DateTime with filter

expand_more
expand_more

How to normalised DateTime in the excel using PowerBI DAX with the StepTime total different for each DOE Leg? StepNo 10 and 11 are repeative for each DOE Leg.

I have created a column for 

StepNo_Repeat = IF('1_DataLog_UnPv'[StepNo] IN {10, 11}, 1, 0)
 
All my DOE Legs happen at different times. I intend to normalise either the DateTime or StepTime so I can compare the same process parameter between Legs.

https://docs.google.com/spreadsheets/d/1TR1vzdFfs3baTQw88nkO4L1hwYrzySln/edit?usp=sharing&ouid=105567561858901921034&rtpof=true&sd=true 

Need Help

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HIHann_Sen

    Can you share a pbix file in a different way? In the sharing method you are currently providing, I am currently unable to open the file you provided.

     

    We recommend that you try uploading the file to OneDrive or SharePoint and sharing the link with us.

     

    Please take care to remove sensitive information from your files.

     

    Best Regards,

    Leroy Lu

     

    • hannsen13's avatar
      hannsen13
      Frequent Visitor
      2 years ago

      Hello Leroy Lu

       

      Please let me know if you can't access the link. It is from OneDrive. I am new to this method of sharing.

       

      Datalog.pbix

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi,hannsen13 and Hann_Sen 

        Sorry for the late reply.

        Thank you for your efforts, but for now I still can't open the file, maybe it's due for sharing:

         

        Please share it with me again and we will do our best to provide ideas for your needs.Please be careful to remove sensitive information.

         

        Best Regards,

        Leroy Lu