Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
venkataramana
Regular Visitor

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
v-xuding-msft
Community Support
Community Support

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
v-xuding-msft
Community Support
Community Support

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.

Thanks Xue Ding. 

Its very helpful for me.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.