This is what I will be showing you in this video. You will learn the advanced table functions I will be using to compare two lists of calculated data virtually to get insights on returning customers and customers who did not return at the same time this year.
This is a useful technique and I hope you enjoy this one.
***** Video Details *****
2:10 calculating Total Customers using COUNTROWS
4:07 calculating last year’s Customers by changing the context of the table using CALCULATETABLE
4:53 changing the time frame using DATESBETWEEN
5:38 comparing customers at current and past year using INTERSECT function
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI -
FREE COURSE - Ultimate Beginners Guide To DAX -
FREE - Power BI Resources -
FREE - 60 Page DAX Reference Guide Download -
Enterprise DNA Membership -
Enterprise DNA Online -
Enterprise DNA Events -
0 Comments