Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI,
I have the sales month starting from Nov-OCT.
I want to get the Highest count among these months starting last Sales year 2019 and current Sales Year2020
Here is the matrix from power bi.
Year | Month | New Count Lines |
2020 | NOV | 4 |
DEC | 5 | |
JAN | 4 | |
FEB | 5 | |
APR | 1 | |
MAY | 12 | |
JUN | 10 | |
2019 | NOV | 5100 |
AUG | 10 | |
SEP | 181 | |
OCT | 15 | |
FEB | 17 | |
MAR | 31 | |
APR | 12 | |
MAY | 20 | |
JUN | 24 | |
JUL | 12 | |
2018 | AUG | 7297 |
SEP | 9462 | |
OCT | 10734 | |
JUL | 7626 |
My output should be 5100, as this is the highest count from 2019 to 2020.
I tried to use this Measure but it gives the highest including the 2018 year aswell. Un able to fix this with Time intelligence.
Any help adjusting this formula?
Measure=
Solved! Go to Solution.
@Anonymous , Try one of the two. First one assume there is filter for 2019, 2020
maxx(summarize(table, table[year],table[month], "_1",[New line count]),[_1])
maxx(summarize(filter(table, Table[Year]>=2019), table[year],table[month], "_1",[New line count]),[_1])
Try this Measure:
@Anonymous ,
Try the below measure:
@Anonymous
Try the below measure:
Thanks All for your reply
Hi @Tahreem24 , Your solution would have worked if New count lines is a column. Mine is a Measure.
Hi @amitchandak your solutions works for me.
Thanks,
Tejaswi
@Anonymous , Try one of the two. First one assume there is filter for 2019, 2020
maxx(summarize(table, table[year],table[month], "_1",[New line count]),[_1])
maxx(summarize(filter(table, Table[Year]>=2019), table[year],table[month], "_1",[New line count]),[_1])
You can try filtering out the year from filter on this visual or filter on this page or use slicer to get the required output.
I did not understand your question as much, correct me if I understood it wrong.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |