How to Replace INFINITY with 0 (Zero) in Power BI

Опубликовано: 13 Октябрь 2024
на канале: Pettaka Technologies

7,318

Learn How to Replace Infinity with 0 (ZERO) in Power BI. With Power BI, we can replace infinity with Zero 0 and show 0 (ZERO) instead of Infinity then show Infinity as 0. We can handle Infinity with DAX Functions in Power BI. You will get more videos like this in Power BI Tutorial Series. ‪@PettakaTechnologies‬
===========================================================
#tutorial #powerbi #daxfunctions #PettakaTechnologies #businessintelligence
===========================================================
Steps To Follow:
1) Data source should contain Infinity values.
2) Select "Infinity" contains column and right click.
3) Enter "IFERROR" DAX function to replace the infinity values.
4) Enter "DIVIDE" DAX function to return 0 as alternate result.
5) In "Alternate Result" of DIVIDE DAX, provide 0.
6) Replace Infinity with 0 and Show 0 instead of Infinity in Power BI.
==========================================================
Learn Business Intelligence with Microsoft Power BI from Pettaka Technologies.
Power BI Tutorial for Beginners 2023.
Power BI by Pettaka Technologies.
Data Visualization with Microsoft Power BI.
==========================================================
This Power BI Replace Infinity with zero Tutorial video covers below topics:

1) How to replace Infinity with 0 (Zero) in Power BI?
2) How to covert Infinity to Zero in Power BI?
3) How to show 0 (Zero) instead of Infinity in Power BI?
4) How to remove Infinity from Power BI?
5) How to Handle Infinity with DAX functions in Power BI Desktop?
6) How to deal with a "(INFINITY)" value in a data source?
============================================================
Playlists:

Microsoft Excel :    • MS Excel Tutorial

Excel VBA Macro :    • Playlist

Power BI :    • 🚀 PowerBI Tutorial for Beginners 😎

Power BI DAX Tutorial :    • Power BI DAX Tutorial
============================================================
For more awesome Power BI Tutorial videos like this. Visit our official YouTube channel.
***************************** - "Pettaka Technologies" - *********************************
========================================================================
Connect with us:
Subscribe |    / pettakatechnologies

Facebook |   / pettakatechnologies

LinkedIn |   / pettaka-technologies

Twitter |   / pettakatech

********************************** - "Happy Learning" - **********************************