Power BI – Calendar Table using DAX Aaj maine Power BI mein Calendar Table create ki aur usme dif...Power BI – Calendar Table using DAX Aaj maine Power BI mein Calendar Table create ki aur usme dif...
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
Eric's avatar
Eric Rajoriya
• Sep 21
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?
Post image
Back to feed
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