top of page
Search


๐๐จ๐ฐ๐๐ซ ๐๐ - ๐๐ฎ๐ง๐ ๐๐๐๐ ๐๐ฉ๐๐๐ญ๐๐ฌ - ๐ ๐๐ฐ ๐ข๐ฆ๐ฉ๐จ๐ซ๐ญ๐๐ง๐ญ ๐๐จ๐ข๐ง๐ญ๐ฌ
June 2021 update of Power BI is out. Few very important points Reporting options: Paginated Report Visual in Power BI Desktop (Preview)...

Vijay Perepa
Jun 26, 20211 min read
ย
ย
ย


Power BI Webinar
Link to the Webinar : MS Teams

Vijay Perepa
Jun 25, 20211 min read
ย
ย
ย


๐๐ฑ๐๐๐ฅ ๐๐๐ ๐๐จ๐ฅ๐ฎ๐ฆ๐ง ๐๐ฎ๐ญ๐จ ๐๐ข๐๐ญ๐ก ๐๐ฎ๐ฌ๐ญ ๐๐ฒ ๐ฌ๐๐ฅ๐๐๐ญ๐ข๐ง๐ ๐๐๐ฅ๐ฅ
Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

Vijay Perepa
Jun 24, 20211 min read
ย
ย
ย

Vijay Perepa
Jun 17, 20210 min read
ย
ย
ย



Vijay Perepa
Jun 2, 20210 min read
ย
ย
ย


For Power BI Learners - What should be the approach!
๐ก๐ผ๐๐ฒ: ๐ ๐ ๐ฅ๐ฒ๐พ๐๐ฒ๐๐ ๐๐ผ ๐๐ต๐ฒ ๐ฟ๐ฒ๐ฎ๐ฑ๐ฒ๐ฟ๐ ๐๐ผ ๐๐ฎ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐ฎ๐ ๐ฎ ๐ณ๐ฒ๐ฒ๐ฑ๐ฏ๐ฎ๐ฐ๐ธ ๐ผ๐ป๐น๐! ๐๐ป๐...

Vijay Perepa
May 15, 20212 min read
ย
ย
ย


๐๐จ๐ง๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐๐๐ซ๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ - ๐๐จ๐ฐ๐๐ซ ๐๐
While dealing with YoY comparisons and Cards, you may require flexibility to show the values based on selection and other conditions. In...

Vijay Perepa
May 11, 20211 min read
ย
ย
ย


๐๐ก๐๐ซ๐ญ๐ข๐๐ฎ๐ฅ๐๐ซ + ๐๐จ๐ฐ๐๐ซ ๐๐ = ๐๐ฎ๐ฌ๐ญ๐จ๐ฆ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ
๐๐จ๐ฐ๐๐ซ ๐๐ ๐๐จ๐ฉ ๐ ๐๐ซ๐จ๐๐ข๐ญ๐๐๐ฅ๐ ๐๐ง๐ ๐๐จ๐ฌ๐ฌ ๐๐๐ค๐ข๐ง๐ ๐๐ซ๐๐ง๐๐ก๐๐ฌ ๐ฎ๐ฌ๐ข๐ง๐ ๐๐ก๐๐ซ๐ญ๐ข๐๐ฎ๐ฅ๐๐ญ๐จ๐ซ...

Vijay Perepa
Apr 25, 20211 min read
ย
ย
ย


There is only one action which doesn't have straight Key Board Short Cut in Excel.
Do you know what is that? And you wish to create your own Short Cut using a single VBA Statement Application.CommandbarsApplication.Comma...

Vijay Perepa
Apr 24, 20211 min read
ย
ย
ย


Know All Functions in Power Query ( M Language)
Get the complete list of Functions available in M Language with small step. Coming up with a new series of Videos . To get notified...

Vijay Perepa
Apr 21, 20211 min read
ย
ย
ย


๐๐ฎ๐ป ๐๐ ๐ฐ๐ฒ๐น ๐ฃ๐ฟ๐ฒ๐๐ฒ๐ป๐ & ๐๐ ๐ฝ๐น๐ฎ๐ถ๐ป ๐๐ต๐ฒ ๐๐ฎ๐๐ฎ ๐น๐ถ๐ธ๐ฒ ๐๐ฒ ๐ฑ๐ผ?
Imagine if Excel started Talking to you and present the Data and Charts and also giving explanation about the Data, and there is less...

Vijay Perepa
Apr 13, 20211 min read
ย
ย
ย


๐๐ฎ๐ฌ๐ญ๐จ๐ฆ ๐๐ข๐ฌ๐ฎ๐๐ฅ๐ฌ ๐ฐ๐ข๐ญ๐ก ๐๐ฒ๐ญ๐ก๐จ๐ง ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐
สแดแดสษด แด แดสษชแดแด๊ฑ แดสแดแดแดษดแด๊ฑ แด๊ฐ แดสแดสแด๊ฑ ษชษด แดแดแดกแดส สษช แดษดแด
แดสแดสแดษด While using a reporting Tool, some times the Customer requirements are tricky and...

Vijay Perepa
Apr 11, 20211 min read
ย
ย
ย



Vijay Perepa
Apr 8, 20210 min read
ย
ย
ย


๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐ฎ๐ป๐ฑ ๐ฃ๐๐๐ต๐ผ๐ป ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป - ๐ง๐ผ๐ฟ๐ป๐ฎ๐ฑ๐ผ ๐๐ต๐ฎ๐ฟ๐
๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ ๐ฎ๐ป๐ฑ ๐ฃ๐๐๐ต๐ผ๐ป ๐๐ป๐๐ฒ๐ด๐ฟ๐ฎ๐๐ถ๐ผ๐ป - ๐ฃ๐๐๐ต๐ผ๐ป ๐ฉ๐ถ๐๐๐ฎ๐น๐ ๐ถ๐ป ๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ - ๐ง๐ผ๐ฟ๐ป๐ฎ๐ฑ๐ผ ๐๐ต๐ฎ๐ฟ๐...

Vijay Perepa
Apr 7, 20211 min read
ย
ย
ย


๐ฃ๐ผ๐๐ฒ๐ฟ ๐๐ - ๐๐ฎ๐น๐ฐ๐๐น๐ฎ๐๐ฒ ๐๐๐๐ฅ (๐๐ผ๐บ๐ฝ๐ผ๐๐ป๐ฑ ๐๐ป๐ป๐๐ฎ๐น ๐๐ฟ๐ผ๐๐๐ต ๐ฅ๐ฎ๐๐ฒ)
CAGR is the rate of return that would be required for an investment to grow from its beginning balance to its ending balance, assuming...

Vijay Perepa
Apr 7, 20211 min read
ย
ย
ย


๐๐จ๐ฐ๐๐ซ ๐๐, ๐๐ฒ๐ญ๐ก๐จ๐ง ๐๐ง๐ญ๐๐ ๐ซ๐๐ญ๐ข๐จ๐ง - ๐๐จ๐ง๐๐ข๐ญ๐ข๐จ๐ง๐๐ฅ ๐ ๐จ๐ซ๐ฆ๐๐ญ๐ญ๐ข๐ง๐
You can run Python scripts directly in Power BI Desktop and import the resulting datasets into a Power BI Desktop data model. To run...

Vijay Perepa
Apr 5, 20211 min read
ย
ย
ย


One Visual - Many Views - Based on Selection - Power BI
Effective use of SELECTEDVALUE() Function

Vijay Perepa
Apr 4, 20211 min read
ย
ย
ย



Vijay Perepa
Mar 31, 20210 min read
ย
ย
ย


Power Query Editor - Merge Queries - Power BI & Excel
Managing Excel Data is some times bit complicated ! Let me explain a scenario which is a real time scenario from a Student ; The Data...

Vijay Perepa
Mar 29, 20211 min read
ย
ย
ย
bottom of page






