Скачать или смотреть Power BI DAX functions: Guide to Using INT & TRUNC for Rounding Figures | DAX Tutorial

DAX INT and TRUNC functions can be used to round figures in Power BI. In this video learn what the INT function and the TRUNC function do in DAX and how to use them.

📩 Free Newsletter: Practical tips on Data, Tools, & Workflow - https://data-for-knowledge.kit.com/si...

🎓 What you will learn:

✅ INT Function in Power BI: Learn how the INT function works by rounding numbers down to the nearest whole number. We’ll explore various examples to show how it handles positive and negative numbers, providing a clear understanding of its behavior.

✅ TRUNC Function Explained: Discover the TRUNC function and how it truncates numbers by removing the fractional part. We also cover the impact of the num_digits parameter, showcasing how it influences truncation precision based on positive and negative values.

✅ Practical Demonstrations: Watch as we apply these functions to a dataset in Power BI, highlighting their differences. We explain how each function affects rounding results and how to choose the right function for your use case.

✅ Tips and Best Practices: We’ll wrap up with recommendations on when to use each function and how to avoid common pitfalls, ensuring you get the desired results every time.

⏱️ Timestamps:
00:00 Introduction: Overview of INT and TRUNC in DAX
00:13 INT function in DAX
02:20 TRUNC function in DAX
04:00 Using Positive num_digits with TRUNC
06:25 Using Negative num_digits with TRUNC

🔗Resources:
📚 Reading - Books from Amazon – https://amzn.to/4jVcnLa
📝 Organising my work with Clickup – https://try.web.clickup.com/8emh4z1sj9w6

Disclosure: I am a participant in the Amazon Services LLC Influencers/Associates program and a participant in the ClickUp Affiliate Program, and I may earn a commission if you click on my referral links and make a purchase. This disclosure is in compliance with the Federal Trade Commission's guidelines on endorsements and testimonials.

✍️ My articles on Medium -   / paulinecairns  

🌐 Microsoft documentation mentioned in the video can be found at:
INT - https://docs.microsoft.com/en-us/dax/...
TRUNC - https://docs.microsoft.com/en-us/dax/...

➡️ Suggested DAX rounding videos:
Guide to CEILING and FLOOR -    • Power BI DAX Guide: Effective Use of CEILI...  
Guide to ROUND ROUNDUP ROUNDDOWN MROUND -    • Power BI - DAX ROUND ROUNDUP ROUNDDOWN MRO...  

💥 For more Power BI & DAX tutorials check out the playlists:
   • Power BI Tutorials | Learn DAX, Charts, AP...  
   • Power BI projects  
   • DAX Functions in Power BI | Complete Power...  

🔥 Popular Power BI and DAX tutorials:
   • Power BI - Text filter visual (Search box)...  
   • DAX - Using SWITCH() to change the backgro...  
   • Power BI - How to insert a line break into...  

🔔 Like and subscribe to the channel for more Power BI tips and tutorials!
   / @dfk_data  

☕ If this tutorial saved you a headache today, you can support the channel via a 'Thanks' or a coffee: https://buymeacoffee.com/dataforknowl...

👉 Follow me on LinkedIn: www.linkedin.com/in/pauline-cairns-data

#powerbi #dax #dataanalysis #datavisualization #roundingnumbers #daxfunctions #powerbitutorial #dataforknowledge #powerbidaxfunction #powerbidax #analytics