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.
Hello,
Need your help in converting my decimal days to this format ( Days Hours Min)
is it possible?
examples:
- 1.5 would be "1 day 12 hours"
- 0.25 would be "0 day 6 hours"
Thank you! 🙂
Solved! Go to Solution.
Here is the formulae for Date in Days and Hours. The same can be replicated for Minutes also.
Hello @Megha166 ,
I tried creating a column, but i encountered below error: what does it mean? 🙂
Thank you!
@icdns wrote:Hello @Megha166 ,
I tried creating a column, but i encountered below error: what does it mean? 🙂
Thank you!
Please send the screenshot or check if above screenshot helps? Basically the error that you are getting says SEARCh is not able to find "." in the date. My code is finding "." in the date and then separating it to Integer and Decimal Part.
Hi @Megha166 ,
I am getting this error. below is the screenshot:
my MAX COMPLAINT PROCESSING DAYS is in DECIMAL FORMAT.
Thank you! 🙂
I see there are so many values as 0(WITHOUT any decimal). These values are throwing the error. Give me sometime. Let me handle these scenarios also in the DAX code.
Can you also give me the expected output of the sample Dates? Would help me test the code.
Hi @Megha166 ,
Wow this is great! I have tried the logic (Date in Text 2) column.. but highlighted occurs..
by the way the max the MAX_FORMAT is the correct one. can I convert the 9967222222223 to just 9 hrs? 🙂
Thank you so much!! Sorry i am very new to powerbi
Please give me the exact input Date that is giving this big 9999***** hours. Also, please Give Kudos to replies if they are helping you 🙂. That's the thumbsup sign below my replies.
Thanks alot for the help!! 😄 For the highlighted one 9996xxxxxxx , it came from measure (max_complaint_processing_date):
You need to give the complete calculation if thats the input Date. Upper Code would just truncate to get first character of the Hours(Here 9).
Mark it Solved if this solves your question.
No Problem. Post the problem again if you still find some issue. Tag Me too. 🙂
Can you give me the Exact Date that you are using?
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 |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |