PowerPivot sum smallest numbers

kent2ben

New Member
Joined
Sep 30, 2014
Messages
1
Hi,

Can anyone help me with a dax syntax that will calculate the sum of the smallest numbers?

weekscategory sales
week 1F3category sales
week 1S10F23
week 1K6S37
week 1K9K8
week 1S7
week 1F20
week 2F20
week 2S30
week 2K10
week 2K2
week 2S90
week 2F40

<colgroup><col width="56" span="7" style="width:42pt"> </colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,090,071
Messages
5,412,171
Members
403,421
Latest member
tammyanthos

This Week's Hot Topics

Top