top of page
Search

Vijay Perepa
Jun 17, 20210 min read
5 views
0 comments



Vijay Perepa
Jun 2, 20210 min read
164 views
0 comments


For Power BI Learners - What should be the approach!
𝗡𝗼𝘁𝗲: 𝗠𝘆 𝗥𝗲𝗾𝘂𝗲𝘀𝘁 𝘁𝗼 𝘁𝗵𝗲 𝗿𝗲𝗮𝗱𝗲𝗿𝘀 𝘁𝗼 𝘁𝗮𝗸𝗲 𝘁𝗵𝗶𝘀 𝗮𝘀 𝗮 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸 𝗼𝗻𝗹𝘆! 𝗔𝗻𝘆...

Vijay Perepa
May 15, 20212 min read
392 views
0 comments


𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐂𝐚𝐫𝐝 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 - 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
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
219 views
0 comments


𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐫 + 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 = 𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬
𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐓𝐨𝐩 𝟓 𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐥𝐞 𝐚𝐧𝐝 𝐋𝐨𝐬𝐬 𝐌𝐚𝐤𝐢𝐧𝐠 𝐁𝐫𝐚𝐧𝐜𝐡𝐞𝐬 𝐮𝐬𝐢𝐧𝐠 𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐭𝐨𝐫...

Vijay Perepa
Apr 25, 20211 min read
226 views
0 comments


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
12 views
0 comments



Vijay Perepa
Apr 23, 20210 min read
80 views
0 comments


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
132 views
0 comments


𝗖𝗮𝗻 𝗘𝘅𝗰𝗲𝗹 𝗣𝗿𝗲𝘀𝗲𝗻𝘁 & 𝗘𝘅𝗽𝗹𝗮𝗶𝗻 𝘁𝗵𝗲 𝗗𝗮𝘁𝗮 𝗹𝗶𝗸𝗲 𝘄𝗲 𝗱𝗼?
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
98 views
0 comments


𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐰𝐢𝐭𝐡 𝐏𝐲𝐭𝐡𝐨𝐧 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
ʟᴇᴀʀɴ ᴠᴀʀɪᴏᴜꜱ ᴇʟᴇᴍᴇɴᴛꜱ ᴏꜰ ᴄʜᴀʀᴛꜱ ɪɴ ᴘᴏᴡᴇʀ ʙɪ ᴀɴᴅ ᴘʏᴛʜᴏɴ While using a reporting Tool, some times the Customer requirements are tricky and...

Vijay Perepa
Apr 11, 20211 min read
1,026 views
0 comments



Vijay Perepa
Apr 8, 20210 min read
196 views
0 comments


𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝗻𝗱 𝗣𝘆𝘁𝗵𝗼𝗻 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 - 𝗧𝗼𝗿𝗻𝗮𝗱𝗼 𝗖𝗵𝗮𝗿𝘁
𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝗻𝗱 𝗣𝘆𝘁𝗵𝗼𝗻 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 - 𝗣𝘆𝘁𝗵𝗼𝗻 𝗩𝗶𝘀𝘂𝗮𝗹𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 - 𝗧𝗼𝗿𝗻𝗮𝗱𝗼 𝗖𝗵𝗮𝗿𝘁...

Vijay Perepa
Apr 7, 20211 min read
504 views
0 comments


𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 - 𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲 𝗖𝗔𝗚𝗥 (𝗖𝗼𝗺𝗽𝗼𝘂𝗻𝗱 𝗔𝗻𝗻𝘂𝗮𝗹 𝗚𝗿𝗼𝘄𝘁𝗵 𝗥𝗮𝘁𝗲)
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
827 views
0 comments


𝐏𝐨𝐰𝐞𝐫 𝐁𝐈, 𝐏𝐲𝐭𝐡𝐨𝐧 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 - 𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐅𝐨𝐫𝐦𝐚𝐭𝐭𝐢𝐧𝐠
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
345 views
0 comments


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

Vijay Perepa
Apr 4, 20211 min read
272 views
2 comments



Vijay Perepa
Mar 31, 20210 min read
32 views
0 comments


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
176 views
0 comments



Vijay Perepa
Mar 23, 20210 min read
309 views
1 comment



Vijay Perepa
Mar 23, 20210 min read
321 views
0 comments


𝐓𝐢𝐦𝐞 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
Time intelligence calculations play very important role while analyzing the data to compare specific periods of current and previous...

Vijay Perepa
Mar 21, 20211 min read
259 views
0 comments
bottom of page