Parse Timestamp

[KHK]

Hi,

could you please let me know how to convert string to date of "4/1/2022 3:48:00 PM".

[KHK]

@anurag,  i am calculating count of PO's for each month.

[KHK]

@anurag Any update?

[anurag]

@KHK you need to join date column in the driving table to date dimension.

Use month column from date dimension and sort it by month_sequence to show months in correct order.

You can also use dual X axis insight to show count by year and month.