cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Create measure based on time intelligence in Power BI,

Hi

 Table1Table1

I have data like above table and I have created a Calendar with Min and Max dates based on above table.

My requirement like

  • Quarter means –> 3 months + Quarter previous month also (Total 4 months)

(Eg: Qtr 1 = Jan.2019 + Feb2019 + March.2019 + Dec.2018

Qtr 2 = Apr.2019 + May.2019 + June.2019 + Mar.2019)

 

  • If we don’t select any year and any Quarter, it will take previous year (2019) is a default year

(if current year = 2020, then previous year = 2019)

 

  • If we select year only and not any Quarter, then it need to show selected year 12 months data + previous year last month data. (Total 13 months)

(Eg: if we select 2019, then it should show Dec.2018 data + 12 months of 2019)

 

  • If we select Quarters only and not any year, then it should show previous year Quarter months data. And it should be 4 months data (3 months of that quarter + previous 1 month)

(Eg: if we select Qrt1, that means Jan.2019 + Feb2019 + March.2019 + Dec.2018)

 

Please help me, how I need to create measures to show the sum of sales for multiple Quarter selectins.

Ex: if I select year=2019 and Quarter = Q1+Q3, then it should show the sum of sales for the period

(Dec.2018 + Jan.2019 + Feb.2019 + Mar.2019 + June.2019 + July.2019 + Aug.2019 + Sept.2019)

YearSlicer.PNG

Thanks inadvance 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Create measure based on time intelligence in Power BI,

Hi @venkataramana ,

 

I created a sample. Please modify and optimize it based on your actual situation.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Create measure based on time intelligence in Power BI,

Hi @venkataramana ,

 

I created a sample. Please modify and optimize it based on your actual situation.

 

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Create measure based on time intelligence in Power BI,

Thanks Xue Ding. 

Its very helpful for me.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors