Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all!
I have this the folllowing time format in DAX (I do not have access to this column in Power BI Editor Query as I buit it in DAX).
I need a DAX function to add a column with this time in decimal format so I can use in a chart. I do not need AM and PM info as I have it in other column.
Much appreciated if you can assist.
Solved! Go to Solution.
Use the FORMAT function to change data types. See this for the various formats you can use.
= FORMAT(Table1[Test],"General Number")
Note it will take AM/PM into account. So 3:32pm would be 0.647222 and 3:32am would be .147222
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUse the FORMAT function to change data types. See this for the various formats you can use.
= FORMAT(Table1[Test],"General Number")
Note it will take AM/PM into account. So 3:32pm would be 0.647222 and 3:32am would be .147222
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThe input was useful.
The solution worked. But the generated column is in the format of text and not able to convert it to decimal number.
I need to aggregate(Sum/average) which is not possible with text format.
Anyone please help me with this.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |