Power BI Abstract Thesis Episode 72: Concatenate text- Measure, DAX Table, and Power Query Table - using ConcatenateX in DAX, Group by in Power Query
-- Content
00:00 Introduction
00:11 Content
06:00 Warp Up
Last Video:
Power BI Abstract Thesis Episode 71: How to filter the slicer of a disconnected table: youtu.be/cV5WfaQt6C8
File Link: dropbox.com/s/cq72rhwo0q59v9p/Half%20year%20till%20date.pbix?dl=0
Source File Location: github.com/amitchandakpbi/powerbi/blob/main/Sales%20Data%20Used%20in%20Video.xlsx
This link will take you to the power bi dashboard that has links for all my blogs and video -You can get all my posts at
community.powerbi.com/t5/Data-Stories-Gallery/Blog-Analysis/m-p/1265567#M4403
Like, Share, comment, and Give suggestions for improvement, and the next post/video.
Important Links every powerbi enthusiastic should bookmark: amitchandak.medium.com/important-links-every-powerbi-enthusiastic-should-bookmark-5682c7a3c912
DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
youtube.com/watch?v=IsfCMzjKTQ0&t=145s
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: youtu.be/aU2aKbnHuWs&t=145s
1. Creating Financial Calendar - From Any Month
community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
2. Any Weekday Week - Start From Any day of Week
community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
3. Week That Resets Yearly
community.powerbi.com/t5/Community-Blog/Week-That-Resets-Yearly-Decoding-Date-and-Calendar-3-5-Power-BI/ba-p/1187502
4. Traveling Across Workdays - What is next/previous Working day
community.powerbi.com/t5/Community-Blog/Travelling-Across-Workdays-Decoding-Date-and-Calendar-4-5-Power/ba-p/1187766
5. Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827
Power BI — Year on Year with or Without Time Intelligence
medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
youtube.com/watch?v=km41KfM_0uA
Power BI — Qtr on Qtr with or Without Time Intelligence
medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
youtube.com/watch?v=8-TlVx7P0A0
Power BI — Month on Month with or Without Time Intelligence
medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
youtube.com/watch?v=6LUBbvcxtKA
Power BI — Week on Week and WTD
medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
youtube.com/watch?v=pnAesWxYgJ8
Day Intelligence - Last day, last non continous day
medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9
-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-
- Abstract Thesis 72: Power BI Concatenate Text- Measure ConcatenateX, DAX Table, Power Query Table ( Download)
- DAX Tutorial - TOPN & Concatenatex ( Download)
- Basics of Power Pivot Dax Measure ConcatenateX Class 2 ( Download)
- DAX - Text Functions Guide | Power BI ( Download)
- DAX - Logical Functions Guide | Power BI ( Download)
