The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Mixed date formats
Synthetic sample from Export Rescue: four dates are standardized as YYYY-MM-DD. Two records go to review: 09/10/2026, which could mean two different dates under the sample rules, and the invalid date 2026-02-30.
The six original records are all accounted for in the cleaned file and review list.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
Excel PivotTable — Sales Summary
Client had raw sales data (14 rows across UK/USA, split by quarter) and needed it turned into something actually usable. I cleaned it up and built a PivotTable that breaks total sales down by rep and country, with grand totals for both.
What I did:
Structured the raw data into a proper table (consistent headers, currency formatting)
Built a PivotTable summarizing Sum of Sales by Last Name and Country
Used SUMIFS so the totals update automatically if the source data changes — nothing hardcoded
Checked every formula for errors before delivery
Delivered as a working .xlsx file, ready to plug into a bigger report or dashboard.
If you've got messy sales/ops data sitting in a spreadsheet and need it turned into something you can actually read at a glance, this is exactly the kind of thing I can help with.
Power BI – Calendar Table using DAX
Aaj maine Power BI mein Calendar Table create ki aur usme different date-related columns banaye:
📅 Daily / Weekly / Monthly analysis
📈 YTD, MTD & QTD calculations
🔄 Time Intelligence
📊 Month-over-Month comparison
📆 Date-based slicers
📉 Sales trends
1️⃣ Calendar Table
Calendar = CALENDAR( MIN(Sales[Order_Date]), MAX(Sales[Order_Date]) )
2️⃣ Year
Year = YEAR('Calendar'[Date])
3️⃣ Month Number
Month No = MONTH('Calendar'[Date])
4️⃣ Month Name
Month Name = FORMAT('Calendar'[Date], "MMMM")
5️⃣ Year Month
Year Month = FORMAT('Calendar'[Date], "MMM YYYY")
6️⃣ Quarter
Quarter = "Q" & QUARTER('Calendar'[Date])
7️⃣ Day
Day = DAY('Calendar'[Date])
8️⃣ Day Name
Day Name = FORMAT('Calendar'[Date], "dddd")
9️⃣ Week Number
Week = WEEKNUM('Calendar'[Date], 2)
🎯 Why Calendar Table?
A proper Calendar Table is very useful for:
📅 Daily / Weekly / Monthly analysis
📈 YTD, MTD & QTD calculations
🔄 Time Intelligence
📊 Month-over-Month comparison
📆 Date-based slicers
📉 Sales trends
Learning Power BI one step at a time! 🚀
I’d love to know from experienced Power BI users:
Is there anything else you would add to this Calendar Table?
Cleaned and validated a synthetic operational dataset containing duplicate records, missing values, invalid entries, and inconsistent formatting. Documented each issue, standardized the data, removed duplicates, and created a data-quality summary to demonstrate a practical end-to-end cleaning and validation workflow.
