Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
May I ask your advice for below issue.
Expectation: define monthly value from the highest value of week in month
Example: in July 2022 have 5 weeks: Wk27, 28, 29, 30, 31, 32
I have 2 factory A and B
Then I want to create a DAX formula returns value of July 2022 for each factory is the value of week have the highest value in month. As data below it should be 22,411 for factory A and 11,533 for factory B.
Issues: my formula return in accurate value, below is the current result with my DAX. It should be 22,411 for factory A not 21,761.
DAX:
Solved! Go to Solution.
@Anonymous , Try like
Sumx(Values(Table[Week]), Maxx(Table,[Stock projection]))
or
Sumx(Values(Table[Week]), Maxx(values(Table[Week]) ,[Stock projection]))
@Anonymous , Try like
Sumx(Values(Table[Week]), Maxx(Table,[Stock projection]))
or
Sumx(Values(Table[Week]), Maxx(values(Table[Week]) ,[Stock projection]))
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |