Solved: Power BI Desktop | Display data for next 5 quarter...

Anonymous · ‎02-09-2019

Hi everyone,

I have data as modelled below,

Expected Output : We would like to display "Count of Title" for current and next 4 quarters.

For example today is 10th Feb 2019, our report should display "Count of Title" for Q1-2019, Q2-2019, Q3-2019, Q4-2019, Q1-2020

Thanks in advance.

Greg_Deckler · ‎02-09-2019

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Greg_Deckler · ‎02-09-2019

See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Power BI Desktop | Display data for next 5 quarters