Working with Time Periods in Power BI

Share this & earn $10
Guy in a Cube
Published at : 15 Dec 2020
18958 views
546
5

How do you work with time periods in Power BI like last month? Patrick digs in to show how you can accomplish this with a little DAX.

Fourmoo Blog: https://www.fourmoo.com/2016/09/07/create-dynamic-periods-for-fiscal-or-calendar-dates-in-power-bi/

Phil Seamark Blog: https://dax.tips/2019/10/09/row-based-time-intelligence/

📢 Become a member: https://guyinacu.be/membership



*******************



Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.



🎓 Guy in a Cube courses: https://guyinacu.be/courses



*******************

LET'S CONNECT!

*******************



-- http://twitter.com/guyinacube

-- http://twitter.com/awsaxton

-- http://twitter.com/patrickdba

-- http://www.facebook.com/guyinacube

-- https://www.instagram.com/guyinacube/

-- https://guyinacube.com



***Gear***

🛠 Check out my Tools page - https://guyinacube.com/tools/



#PowerBI #TimePeriods #GuyInACube
power bipower bi dashboardpower bi desktop

Income statements | How to prepare a Trading account | Cost of goods sold section | CSEC PoA

Income statements | How to prepare a Trading account | Cost of goods sold section | CSEC PoA

Dani Mocanu 🏅 Asasin 2 ⚰️ | Official Video

Dani Mocanu 🏅 Asasin 2 ⚰️ | Official Video

Trust Yourself - The Art Of Self Reliance

Trust Yourself - The Art Of Self Reliance

REVIEWING A NASTY 1 STAR HOTEL IN HOLLYWOOD *GROSS*

REVIEWING A NASTY 1 STAR HOTEL IN HOLLYWOOD *GROSS*

HOW TO LIVE OFF INVESTMENTS & DIVIDENDS - Investing for Income and Financial Independence

HOW TO LIVE OFF INVESTMENTS & DIVIDENDS - Investing for Income and Financial Independence

Black sabbath - A bit of finger, Sleeping village, Warning, Wicked world

Black sabbath - A bit of finger, Sleeping village, Warning, Wicked world

Peaceful Summer | Instrumental Vibes

Peaceful Summer | Instrumental Vibes

THE STORY OF 50 MONETISED CHANNEL 2020

THE STORY OF 50 MONETISED CHANNEL 2020

Five Kids The Floor is Lava Song + more Children's Songs and Videos

Five Kids The Floor is Lava Song + more Children's Songs and Videos

Drawn History: The Trojan War | History

Drawn History: The Trojan War | History

플로어스(flor_us) - 잊지 않기로 해(Do not forget) M/V (Official Music Video)

플로어스(flor_us) - 잊지 않기로 해(Do not forget) M/V (Official Music Video)

Natural Movement for Body Suppleness

Natural Movement for Body Suppleness

Zebra Luminae Walkthrough

Zebra Luminae Walkthrough

The BEST Features of Star Citizen 3.12!

The BEST Features of Star Citizen 3.12!

Zedd, Grey - The Middle (Lyrics) ft. Maren Morris

Zedd, Grey - The Middle (Lyrics) ft. Maren Morris

The Ground

The Ground

How Neville Goddard Manifested Marrying His Specific Person!

How Neville Goddard Manifested Marrying His Specific Person!

Azerbaijan responded to the July provocation of the Armenians on all fronts.

Azerbaijan responded to the July provocation of the Armenians on all fronts.

Grasping The Illusory Nature Of Thought

Grasping The Illusory Nature Of Thought

18 MATH RIDDLES THAT EVEN YOUR MATH TEACHER WILL FAIL

18 MATH RIDDLES THAT EVEN YOUR MATH TEACHER WILL FAIL

Naturalize & Benzoo - One Among Many (Official Audio)

Naturalize & Benzoo - One Among Many (Official Audio)

MAXIMUM ATTACK in Porsche GT3 RS | Nürburgring & Pro Driver

MAXIMUM ATTACK in Porsche GT3 RS | Nürburgring & Pro Driver

Wondering - Liquid Drum & Bass Mix 2013 HD

Wondering - Liquid Drum & Bass Mix 2013 HD

10 Ways To Tie A Scarf - He Spoke Style

10 Ways To Tie A Scarf - He Spoke Style

WON STACKS OF CASH FROM MONEY CLAW MACHINE! | JOYSTICK

WON STACKS OF CASH FROM MONEY CLAW MACHINE! | JOYSTICK

Will OPEC Spark Oil Price War With Production Cuts?

Will OPEC Spark Oil Price War With Production Cuts?

Evaporation of perennial semi-arid woodland in south eastern Australia is adapted

Evaporation of perennial semi-arid woodland in south eastern Australia is adapted

Architects - "Animals"

Architects - "Animals"

Big News for RKT: Rocket Companies Insider Selling After Lock Up Expiration?

Big News for RKT: Rocket Companies Insider Selling After Lock Up Expiration?

The Quantity Surveyor Handbook

The Quantity Surveyor Handbook

Why South Korea Is the Plastic Surgery Capital of the World | The Plastics | Harper's BAZAAR

Why South Korea Is the Plastic Surgery Capital of the World | The Plastics | Harper's BAZAAR

Sincere Meaning

Sincere Meaning

Best songs in 2020 | Most loved Learn Colors & Sing Along Series! | Kids' Favorite | Play with Hogi

Best songs in 2020 | Most loved Learn Colors & Sing Along Series! | Kids' Favorite | Play with Hogi

Glide Meaning

Glide Meaning

2020 The Terrible Horrible No Good Very Bad Year For The Prophets

2020 The Terrible Horrible No Good Very Bad Year For The Prophets

Fortuitous - Word of the Day with Lance Conrad

Fortuitous - Word of the Day with Lance Conrad

Cemeteries - Luna (Moon Of Claiming) (Sub Español)

Cemeteries - Luna (Moon Of Claiming) (Sub Español)

How to introduce yourself in English

How to introduce yourself in English

Matt Guillory - It Won't Last (Official Lyric Video)

Matt Guillory - It Won't Last (Official Lyric Video)

B-Front | Defqon.1 at Home 2020

B-Front | Defqon.1 at Home 2020

Njoo: Canada making plans for widespread distribution even as Pfizer COVID-19 vaccine approved

Njoo: Canada making plans for widespread distribution even as Pfizer COVID-19 vaccine approved

【高校英文法講座#51】11-a. so as toとso that

【高校英文法講座#51】11-a. so as toとso that

EMDI x RØGUENETHVN - Let Your Heartbreak (feat. Leo the Kind) [NCS Release]

EMDI x RØGUENETHVN - Let Your Heartbreak (feat. Leo the Kind) [NCS Release]

Cartoon Box Catch Up 10 | the BEST of Cartoon Box | Hilarious Cartoon Compilation

Cartoon Box Catch Up 10 | the BEST of Cartoon Box | Hilarious Cartoon Compilation

Maroon 5 - Misery (UK Version) (Official Music Video)

Maroon 5 - Misery (UK Version) (Official Music Video)

Music Bank 뮤직뱅크 - I.O.I 아이오아이- Vary Vary Vary 너무너무너무.20161104

Music Bank 뮤직뱅크 - I.O.I 아이오아이- Vary Vary Vary 너무너무너무.20161104

Modicare | Modicare new offers | Modicare new update | Modicare new offer 2021 | Modicare loyalty

Modicare | Modicare new offers | Modicare new update | Modicare new offer 2021 | Modicare loyalty

Seasons on Earth | #aumsum #kids #science #education #children

Seasons on Earth | #aumsum #kids #science #education #children

Watch this video only if it is recommended to you

Watch this video only if it is recommended to you