DAX Fridays! #127: Calculate Same period last Month in DAX
Comparing periods is something you should always do as it adds context to your data, but how do
you calculate Same period last month? PREVIOUSMONTH function will give you the entire previous month, so how do you do it?
#powerbi #curbal #dax #daxfridays
Here is one of the many ways to do it.
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: https://curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi #mvp
Видео DAX Fridays! #127: Calculate Same period last Month in DAX канала Curbal
you calculate Same period last month? PREVIOUSMONTH function will give you the entire previous month, so how do you do it?
#powerbi #curbal #dax #daxfridays
Here is one of the many ways to do it.
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Fridays survey: http://bit.ly/2MMM4KK
Here you can download all the pbix files: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://curbal.com/product/sponsor-me
Many thanks in advance!Here you can download all the pbix files: https://curbal.com/donwload-center
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► https://goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► https://goo.gl/bME2sB
#daxfridays #curbal #dax #powerbi #mvp
Видео DAX Fridays! #127: Calculate Same period last Month in DAX канала Curbal
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Comparing with previous selected time period in DAXHow to compare SAME PERIOD LAST MONTH in Power BI using DAX // Beginners Guide to Power BIThis year vs Last year Calculation in Power BI using DAXFeature summary for Power BI June 2022 updateCalculate Difference This Year vs Last Year in Power BI with DAXPrevious Dynamic Period using DAX in Power BIDAX Fridays! #124: Weekly time intelligence in Power BIShow last 6 months based on user single slicer selectionMonth over Month Calculation in Power BI using DAXCalculating Month On Month Change - Custom (445) Calendars, Power BI & DAXGet Multiple Files Containing Multiple Sheets with Power QueryPower BI Time Intelligence: Next Month and Previous MonthMastering field parameters in Power BI | A practical and common use caseShow MTD, QTD & YTD Calculations To Current Date in Power BI w/DAXPower BI dataflows: Where does it fit in? (Matthew Roche schools Patrick)Power Query Drill Down and Formula.Firewall Error ExplainedHow to Compare Time Periods in Power BI [PREVIOUSMONTH, PARALLELPERIOD, and DATEADD]How to Return Value based on most recent date in PowerBITime Intelligence in Power BI - Marco Russo