top of page
Search


Vijay Perepa
May 15, 20212 min read
For Power BI Learners - What should be the approach!
𝗡𝗼𝘁𝗲: 𝗠𝘆 𝗥𝗲𝗾𝘂𝗲𝘀𝘁 𝘁𝗼 𝘁𝗵𝗲 𝗿𝗲𝗮𝗱𝗲𝗿𝘀 𝘁𝗼 𝘁𝗮𝗸𝗲 𝘁𝗵𝗶𝘀 𝗮𝘀 𝗮 𝗳𝗲𝗲𝗱𝗯𝗮𝗰𝗸 𝗼𝗻𝗹𝘆! 𝗔𝗻𝘆...
392 views0 comments


Vijay Perepa
May 11, 20211 min read
𝐂𝐨𝐧𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐂𝐚𝐫𝐝 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 - 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
While dealing with YoY comparisons and Cards, you may require flexibility to show the values based on selection and other conditions. In...
219 views0 comments


Vijay Perepa
Apr 25, 20211 min read
𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐫 + 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 = 𝐂𝐮𝐬𝐭𝐨𝐦 𝐕𝐢𝐬𝐮𝐚𝐥𝐬
𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐓𝐨𝐩 𝟓 𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐥𝐞 𝐚𝐧𝐝 𝐋𝐨𝐬𝐬 𝐌𝐚𝐤𝐢𝐧𝐠 𝐁𝐫𝐚𝐧𝐜𝐡𝐞𝐬 𝐮𝐬𝐢𝐧𝐠 𝐂𝐡𝐚𝐫𝐭𝐢𝐜𝐮𝐥𝐚𝐭𝐨𝐫...
226 views0 comments


Vijay Perepa
Apr 24, 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...
12 views0 comments




Vijay Perepa
Apr 21, 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...
132 views0 comments

Vijay Perepa
Apr 13, 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...
98 views0 comments


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




Vijay Perepa
Apr 7, 20211 min read
𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝗻𝗱 𝗣𝘆𝘁𝗵𝗼𝗻 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 - 𝗧𝗼𝗿𝗻𝗮𝗱𝗼 𝗖𝗵𝗮𝗿𝘁
𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗮𝗻𝗱 𝗣𝘆𝘁𝗵𝗼𝗻 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 - 𝗣𝘆𝘁𝗵𝗼𝗻 𝗩𝗶𝘀𝘂𝗮𝗹𝘀 𝗶𝗻 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 - 𝗧𝗼𝗿𝗻𝗮𝗱𝗼 𝗖𝗵𝗮𝗿𝘁...
504 views0 comments


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...
826 views0 comments


Vijay Perepa
Apr 5, 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...
340 views0 comments


Vijay Perepa
Apr 4, 20211 min read
One Visual - Many Views - Based on Selection - Power BI
Effective use of SELECTEDVALUE() Function
272 views2 comments




Vijay Perepa
Mar 29, 20211 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...
176 views0 comments




Vijay Perepa
Mar 23, 20210 min read
321 views0 comments


Vijay Perepa
Mar 21, 20211 min read
𝐓𝐢𝐦𝐞 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
Time intelligence calculations play very important role while analyzing the data to compare specific periods of current and previous...
259 views0 comments



Vijay Perepa
Mar 20, 20211 min read
Create your Own Custom Visuals in Power BI
Tutorial will posted shortly, to get notified Please do SUBSCRIBE
316 views0 comments
bottom of page