I need to create a unique code adding string and date , also need to convert date to timestamp

I have an exemptions sheet stored in Sharepoint where users can add the items they wish to exempt , due to issues with how the dates display in excel when users add their exemptions , I used an epoch timestamp which fixed the issue.
In PowerBI I used to convert the datetime to the time stamp using this formula
Time stamp = (
‘TU Feed’[Departure Date]
- DATE ( 1970, 1, 1 )
) * 86400
The date time format is 2022-06-16 00:58:00.000

Then to get the unique exemption string , I added this formula , I turned it into a fake url , so it does not take up space in visual , showing just link icon

TU Ex = “https://exemption.com/” & ‘TU Feed’[Reg No.] & “/” & ‘TU Feed’[Time Stamp]

Is there a way this can be done in Quicksight please , I also need to have it done in dataset as I need to do a left join to the exemptions table by TU Ex


Thanks for reaching out. I think the parseDate function is what you are looking for.


Hi, @dev_opra. Did @SeanBoon’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!