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