Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |