Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |