Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In my report i want to show a date time value .The date time value i want is american chicago date time ...How can i get ?
Solved! Go to Solution.
@nisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@nisha_deepak You could try in DAX a new measure:
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@nisha_deepak ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if these can help
https://community.powerbi.com/t5/Desktop/Convert-utc-to-local-time-zone-using-Power-Query/td-p/45533
https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
Appreciate your Kudos.
hi,
currently utc datetime value is showing as column value in my report.I want to change utc to american chicago date time value in my report as column.Now i added a custom column with DateTimeZone.SwitchZone(DateTimeZone.UtcNow(), -6 ) like this,,,Is this correct.
@nisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |