fbpx

Archive for March, 2025

Easily Convert JSON to Excel – Step by Step Tutorial

Published on Mar 18, 2025 in Excel Howtos
Easily Convert JSON to Excel – Step by Step Tutorial

JSON (JaveScript Object Notation) is a popular and easy format to store, share and distribute data. It is often used by websites, APIs and streaming (real-time) systems. But it is also cumbersome and hard to use for performing typical data tasks like summarizing, pivoting, filtering or visualizing. That is why you may want to convert […]

Continue »

New vs. Returning Customers Analysis with DAX [Easy Formulas]

Published on Mar 4, 2025 in Power BI, Power Pivot
New vs. Returning Customers Analysis with DAX [Easy Formulas]

DAX offers powerful way to analyze “new” vs. “returning” customers. In this article learn easy and simple DAX measure patterns to count number of new customers and number of returning customers from your data. What is a Returning Customer? A returning customer is someone who comes back to our business and does another transaction. For […]

Continue »