topic Re: Normalized DateTime with filter in DAX Commands and Tips

Normalized DateTime with filter

Hann_Sen — Sun, 07 Jul 2024 08:52:17 GMT

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

Re: Normalized DateTime with filter

Anonymous — Mon, 08 Jul 2024 02:38:10 GMT

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

Re: Normalized DateTime with filter

hannsen13 — Wed, 10 Jul 2024 04:06:26 GMT

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

Re: Normalized DateTime with filter

Anonymous — Thu, 18 Jul 2024 09:01:19 GMT

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

Re: Normalized DateTime with filter

hannsen13 — Fri, 26 Jul 2024 00:02:06 GMT

Hello

I have uploaded the file to Google Drive.

Please try to download it.

https://drive.google.com/file/d/10CiGCc8IBfU9LQsPVcwxObhl03q7ckwh/view?usp=drive_link

Re: Normalized DateTime with filter

Anonymous — Fri, 26 Jul 2024 01:32:13 GMT

Hi,hannsen13

Thanks for the quick reply.

I understand your frustration, but I'd like to ask you to share it in a different way.

Due to our security practices, we do not have access to data sharing from Google.If you need our help, please share your PBIX file.I would be grateful if you could provide me with the pbix file or sample data.SharePoint and OneDrive are recommended.

When uploading a file, please be careful to delete sensitive information.

If you have any other questions please feel free to contact me.

Best Regards,

Leroy Lu

Re: Normalized DateTime with filter

hannsen13 — Fri, 26 Jul 2024 03:12:47 GMT

Hello Leroy

Do you have an email for me to share?

Re: Normalized DateTime with filter

Anonymous — Fri, 26 Jul 2024 03:41:11 GMT

Hi,hannsen13
Thanks for the quick reply.

Due to our security protocols, email addresses are not allowed, and we recommend that you use SharePoint and OneDrive links for sharing.

Thank you for your understanding.

Best Regards,

Leroy Lu

Re: Normalized DateTime with filter

hannsen13 — Fri, 26 Jul 2024 04:07:00 GMT

Hello Leroy

Please try to access it; I have it open to anyone.

Datalog.pbix

Re: Normalized DateTime with filter

hannsen13 — Sun, 04 Aug 2024 07:00:59 GMT

Have you manage to assess it?

Re: Normalized DateTime with filter

Anonymous — Wed, 07 Aug 2024 06:42:13 GMT

Hi,hannsen13

Thank you for your reply.

But to be honest, I still can't open the file you've shared, which is bad news.

However, you can try sharing using SharePoint or sharing your files using text. You may want to be aware that you can make sure that others have access to and erase sensitive information.

Here are the relevant links that we hope you will find helpful:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Solved: How to upload PBI in Community - Microsoft Fabric Community

Thank you for your efforts.

Best Regards,

Leroy Lu

topic Re: Normalized DateTime with filter in DAX Commands and Tips

Normalized DateTime with filter

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

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

Re: Normalized DateTime with filter

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