Vikas Kashyap

Behind the Scenes: DAX Logic for Gantt Chart Status

I recently built a DAX measure to automatically determine whether a project is Completed, Delayed, or Open inside a Gantt chart.

The logic checks the project’s start/end dates, identifies if today falls within that range, and...

Some problems in Power BI look simple… until you try to solve them.

Recently, I was working on a dashboard where I needed something very specific: 👉 Identify the 2nd highest Salesperson based on Total Finance.

Sounds easy, right? Until you realize that DAX doesn’t have a direct...

Built a marketing and traffic source analytics dashboard using GA4 and Looker Studio. Transformed raw acquisition data into a clear, insight-driven overview highlighting top channels, user behavior, engagement, and conversion performance. Designed custom visualizations, applied...

Developed an executive-level ecommerce analytics dashboard for the Google Merchandise Store using GA4 and Looker Studio. Consolidated key metrics—traffic, engagement, product performance, and conversions—into a clear, high-impact overview. Integrated GA4 data, applied custom...