Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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]
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.
Hello,
You can try this below, by going through New table
New Table=SUMMARIZE('Date','Date'[Quarter],"Max",MAX('Date'[Period]))
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
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]
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
Proud to be a Super User!
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |