Welcome to Reckon Analytics!

We are two passionate and relentlessly committed analytics professionals who are highly obsessed with data. We advocate data viz communities to bring best out of the available data for a business. We aim to ease out the complex data science with the help of lucid and interactive dashboards for the novice.

We can provide analytics solutions in the jiffy. We’re confident that once you see what we can score in a short amount of time, you’ll be keen to see what we’re capable of on a data visualisation project. Enough about us, let’s talk about your business.

If you want to discover the answer to questions from unstructured or structured business data, then you need us!


We offer a range of services to help you achieve the results you’re after. Not sure what you need, or what it costs? We can explain what services are right for you and tell you more about our fees. Get in touch below.

  • DAX and PowerPivot Calculations
  • Power Query Transformations
  • Creating a Power BI connector or get data into Power BI form different sources
  • Visualization and reporting
  • Implementing Power BI in the enterprise


Sort by Year – Week in Power BI

In Power BI, if you are creating year-week sales report, then you will encounter a most common issue. i.e Power BI by default return single digit week number/month number. Default Sorting in Power BI: But desired results is: 2018-12 2018-11 2018-09 2017-01 Using this formula once can fix this problem: Year-Month= Data[a_date].[Year]&”-“&FORMAT(Data[a_date].[MonthNo],”00″) Year-Week= Data[a_date].[Year]&”-“&FORMAT((Data[a_date].[MonthNo],1),”00”)


We are a small team of talented professionals with a wide range of skills and experience. We love what we do, and we do it with passion. We look forward to working with you.

Shruti Goyal

Certified: Microsoft Power BI, ITIL, TM1 BI Suite, SAS

Deepak Gupta

Certified: Microsoft Power BI, SAS v9,Google Analytics