topic Re: how to convert date time UTC to IST format in powerbi in DAX Commands and Tips

how to convert date time UTC to IST format in powerbi

krishna_murthy — Fri, 26 Sep 2025 18:44:49 GMT

I have an more than 20 tables. which is connected semantic model from SQL to Powerbi, while getting the data into powerbi Data is came like in UST format. due to that data count is mismatch from IST count. So i want to know how to convert/change the data powerbi with match the count in IST values and look for any fesiable options like Power query & DAX or any other way.
. Please suggest further.

Re: how to convert date time UTC to IST format in powerbi

Ahmed-Elfeel — Sat, 27 Sep 2025 06:20:14 GMT

Hi krishna_murthy,

You can use Power query (most efficient and sustainable method)

Go to Power Query Editor
Select your date/time column
Use this formula in a Custom Column
(Replace YourColumnName with your actual column name)

DateTime.Add([YourColumnName], #duration(0, 5, 30, 0))

Change the new column's type to Date/Time
Replace the original column with this new one
Repeat for all key date columns in your 20 tables

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Sat, 27 Sep 2025 11:30:20 GMT

Hi Ahmed-Elfeel ,
See getting below error like this, requesting please check and do the needful

Re: how to convert date time UTC to IST format in powerbi

Ahmed-Elfeel — Sat, 27 Sep 2025 14:05:38 GMT

Hi krishna_murthy,

Try to use DateTime.From instead of DateTime.Add:

Table.AddColumn("Proofered Column", "HwDateTime", each DateTime.From([order_items]) + #duration(0,5,30,0))

Or even Simpler:

Table.AddColumn("Proofered Column", "HwDateTime", each [order_items] + #duration(0,5,30,0))

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: how to convert date time UTC to IST format in powerbi

raja1992 — Sat, 27 Sep 2025 15:01:47 GMT

I ran into this same problem last month when I connected our SQL Server sales data to Power BI. All the order timestamps were in UTC, and when I tried to do daily sales counts, the numbers didn’t match what our business team in India was seeing (because they work in IST).

What worked for me was fixing it in Power Query. Example:

My column was OrderDateUTC = 2025-09-27 20:00:00 (UTC).
I added a custom column like this:

Table.AddColumn( #"Previous Step", "OrderDateIST", each DateTimeZone.SwitchZone([OrderDateUTC], 5.5) )

This converted it to 2025-09-28 01:30:00 (IST), which matched exactly with our backend counts.

If you prefer DAX, you can also create a calculated column:

OrderDateIST = Sales[OrderDateUTC] + TIME(5,30,0)

But since I had 20+ tables, I found Power Query was cleaner because once I fixed it there, all measures and visuals automatically aligned with IST.

Small tip: if you have SQL access, you can also do this directly in SQL using:

SELECT OrderDate AT TIME ZONE 'UTC' AT TIME ZONE 'India Standard Time'

That way, Power BI always receives IST values.

In short, if you want consistent daily counts in IST, go with the Power Query solution.

Re: how to convert date time UTC to IST format in powerbi

tayloramy — Sat, 27 Sep 2025 16:39:20 GMT

Hi krishna_murthy

-Best practice: convert UTC to IST as early as possible (ideally in SQL or Power Query) and then build your date columns from the IST value.
- For SQL Server: convert in the source using AT TIME ZONE.
- For Power Query (M): add a timezone, switch to IST, then remove the zone.
- DAX is OK for display, but it will not help DirectQuery and can lead to confusing group-bys; prefer SQL or Power Query for reliable totals.
Docs: AT TIME ZONE (T-SQL), DateTime.AddZone, DateTimeZone.SwitchZone, DateTimeZone functions, UTCNOW (DAX), DAX date/time functions.

1) Do it in SQL Server (recommended if you control the source)
Use AT TIME ZONE to translate UTC to IST and then derive your date keys from the IST column. IST has a fixed offset (+05:30) and no DST, so this is stable.

-- Example: convert UTC column to IST SELECT t.EventUTC, -- Convert UTC -> IST (t.EventUTC AT TIME ZONE 'UTC') AT TIME ZONE 'India Standard Time' AS EventIST, -- Build date for grouping in IST CONVERT(date, ((t.EventUTC AT TIME ZONE 'UTC') AT TIME ZONE 'India Standard Time')) AS EventISTDate FROM dbo.YourTable AS t;

Docs: AT TIME ZONE.

2) Do it in Power Query (M) in Power BI Desktop
If your column is plain datetime (no zone), first tag it as UTC, switch to IST, then remove the zone so the value is a normal datetime in IST. After that, create your date column from the IST value.

// Replace YourTable and UtcTime with your names let Source = YourTable, // Treat existing datetime as UTC WithUtcZone = Table.TransformColumns(Source, {{"UtcTime", each DateTime.AddZone(_, 0), type datetimezone}}), // Switch to IST (UTC+5:30) ToIST = Table.TransformColumns(WithUtcZone, {{"UtcTime", each DateTimeZone.SwitchZone(_, 5, 30), type datetimezone}}), // Remove zone to get a plain datetime in IST IstDateTime = Table.TransformColumns(ToIST, {{"UtcTime", each DateTimeZone.RemoveZone(_), type datetime}}), // Optional: add a date column for grouping IstDate = Table.AddColumn(IstDateTime, "IstDate", each DateTime.Date([UtcTime]), type date) in IstDate

Docs: DateTime.AddZone, DateTimeZone.SwitchZone, DateTimeZone functions.

3) DAX only (display or Import models; not ideal for grouping)
If you already imported data and must adjust in the model, create an IST column and then build your date from it. Note: this does not work in DirectQuery for calculated columns.

-- Add 5 hours 30 minutes to convert UTC to IST IST DateTime = 'Table'[UtcTime] + TIME(5, 30, 0) IST Date = DATE( YEAR('Table'[IST DateTime]), MONTH('Table'[IST DateTime]), DAY('Table'[IST DateTime]) )

Docs: DAX date/time functions, UTCNOW.

4) Notes and pitfalls
- Power BI Service uses UTC for NOW/TODAY variants; if you rely on those, be aware of the UTC behavior. See: UTCNOW and DAX date/time functions.
- For DirectQuery, prefer doing the conversion in SQL with AT TIME ZONE so grouping and filters reflect IST correctly.
- After converting, always derive your grouping columns (like Date) from the IST value, not the original UTC column.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Sun, 28 Sep 2025 05:47:19 GMT

Hi i have used both the cased but still getting an error see below , seems direct query not suppported for the beow conditions

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Sun, 28 Sep 2025 06:04:05 GMT

Hi raja1992 , i have tried your inputs but getting an error like below, seems direct query not working ,
Requesting please check and do the neeful

Re: how to convert date time UTC to IST format in powerbi

Ahmed-Elfeel — Sun, 28 Sep 2025 11:50:26 GMT

Hi krishna_murthy,

Direct Query mode doesn't support many Power Query transformations

So you can try these options:

1-Switch to Import Mode (Recommended)

Go to Power BI Desktop → Settings → Current File → DirectQuery
Switch your semantic model/tables to Import mode
Then use the Power Query method:

[order_time] + #duration(0,5,30,0)

2-DAX Calculated Column (For Direct Query)

In Data view, right-click your table → New column
Use this DAX formula:

HwDateTime = [order_time] + TIME(5,30,0)

3-SQL View (Best long-term solution)

Modify your SQL view to convert UTC to IST before data reaches Power BI:

SELECT DATEADD(MINUTE, 330, order_time) as order_time_IST FROM your_table

I hope these approaches is useful....Please Use reply buttone next time to trace the problem 😅❤️

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Mon, 29 Sep 2025 06:22:38 GMT

Ahmed-Elfeel ,

i have tried all the option except sql but getting below error , please refer the below screenshot for your references

Re: how to convert date time UTC to IST format in powerbi

V-yubandi-msft — Mon, 29 Sep 2025 14:02:02 GMT

Hi krishna_murthy ,

Thank you for contacting the Fabric Community. Could you review the snapshot below and confirm if this matches your expectations? We have used the IST conversion logic to adjust the timestamps, so the output should now show the correct daily grouping.
FYI:

Please let us know if this addresses your concern or if you need any further changes.

Thank you.

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Wed, 01 Oct 2025 08:05:03 GMT

Ahmed-Elfeel ....
i have tired DAX as create a calculated column
(OrderDateIST = outward_orders[order_time] + TIME(5,30,0) ) and added to the slicer to filter date but getting below error

Requesting please check and do the neeful .

Re: how to convert date time UTC to IST format in powerbi

V-yubandi-msft — Fri, 03 Oct 2025 05:46:46 GMT

Hi krishna_murthy ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you or let us know if you need any further assistance.

Re: how to convert date time UTC to IST format in powerbi

krishna_murthy — Fri, 03 Oct 2025 14:16:16 GMT

V-yubandi-msft >>>

After added the condtion getting below error , requesting please check and the needful .

Re: how to convert date time UTC to IST format in powerbi

V-yubandi-msft — Wed, 08 Oct 2025 09:17:28 GMT

Hi krishna_murthy ,

Thank you for providing the details. This error usually indicates that Power Query cannot locate the step name Added Custom. This often occurs due to a typo or a mismatch in the step name.

You can try the following steps.

1. Review the Applied Steps pane to ensure the previous step name matches exactly, including spaces and capitalization.
2. Update your formula to use the correct step name. For example

= Table.RenameColumns(#"Added Custom", {{"Custom", "IST"}})

If you are adding a new column

= Table.AddColumn(#"PreviousStepName", "IST", each [Custom])

Once the reference is correct, it should display the IST values as expected.

Please try these suggestions and let me know if the issue persists so we can review it together.

Re: how to convert date time UTC to IST format in powerbi

V-yubandi-msft — Mon, 13 Oct 2025 07:01:13 GMT

Hi krishna_murthy ,
Could you let me know if your issue has been resolved or if you still need any more information? If you need further help, please let us know.