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
Swamy3105
Helper IV
Helper IV

Need Help

Hi Experts,

 

I have a data and i need to find out what is the max period in the below data.

 

please help me on this.

 

Period            Quarter

1                       Q1

2                       Q1

3                       Q1

4                       Q2

5                       Q2

 

So, if

Q1 the maximum period is  = 3

Q2 the maximum period is  = 5

 

likewise i want to find out the maximum period in the each quarter.

 

How to get this done?

 

Regards

Swamy  

 

1 ACCEPTED SOLUTION

Hi  @Swamy3105 

Create measures

max period = CALCULATE(MAX(Table1[Period]),ALLEXCEPT(Table1,Table1[Quarter]))

month plan = MAX([Year plan])/12

Quarter plan = [max period]*[month plan]

3.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
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

5 REPLIES 5
sampathK
Employee
Employee

Hello,

   You can try this below, by going through New table 

 

New Table=SUMMARIZE('Date','Date'[Quarter],"Max",MAX('Date'[Period]))

AiolosZhao
Memorable Member
Memorable Member

Hi @Swamy3105 ,

 

I'm not sure how you want to use the maxinum, beucase I think you can put the quarter as dimension in table, and create a measure ( =max(period), then you can get the maxinum period by quarter I think.

 

Please try.

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi,

 

I want to calculate the QTD plan numbers for each quarter.

 

If I get the maximum period of the Quarter then i can calculate the plan numbers again each order.

 

Ex:

 

Yearly plan is 1000

monthly plan is 1000/12 = 83.33

so if I want to calculate the QTD value for Q1 = 3*83.33 = 250

 

Hope u can understand the scenario.

 

Regards

Swamy

Hi  @Swamy3105 

Create measures

max period = CALCULATE(MAX(Table1[Period]),ALLEXCEPT(Table1,Table1[Quarter]))

month plan = MAX([Year plan])/12

Quarter plan = [max period]*[month plan]

3.png

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @Swamy3105 ,

 

So I assume that you already have a measure to get the result of monthly plan.

And if you want to create a table, then I think you just need to put the quarter into the table.

then create a measure like : a = max(period)

then create another measure like :  b = a * your_monthly_plan

then put b into your table.

 

Please try.

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.