COMBINEVALUES in Databricks/Spark Direct Query cannot be folded

Hi,

As per our understanding, you want a Calculated Column in Power BI which include combined value from Unique ID and Timestamp column.

We can see in your Given Data the Date/Time is in 24.01.2023 00:06:28

which contains the " . " instead of the /  but the Date Time Format in Power BI do not include any of the format using “.”

So, you need to first convert the current data into correct format by creating a new Calculated column for the Timestamp with Following Dax Expression:

New TimeStamps = SUBSTITUTE('Sample Table'[TIme Stamp],".","/")

Then Create the Desired Column CompositeKey Using the Below Dax Expression,

CompositeKey = COMBINEVALUES("-",'Sample Table'[Unique ID],FORMAT('Sample

Table'[New TimeStamps],"m/d/yy hh:nn:ss"))

This will result in combined values as shown in the below screenshot,

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/