grouped field

2 Topics

Calculating groups
Dear community, I am facing a challenge to group sales from a fairly simple table. The table have total sales generated on both "OrderType" and "SalesChannel" which sums up to the same. However I would like to change the setup with the following needs, preferably through dax (running direct query): "Dining-In Sales" should only appear once "Pick-Up Sales" should be zeroed "Online Sales" should be calculated as follows: Online Sales - all Providers Sales The decired result you can see on the right hand side. Thanks in advance.
Molin
3 years ago Place DAX Commands and Tips
886Views
0likes
2Comments
Filter virtual table to keep most recent dates by user and goal type
If I have users Jeff and Steve, and each can update there different goal types (products sold & cold calls).. I'd like a measure that iterates a virtual table and returns the most recent (max date) goal amount set (by name and goal type). See example below, and highlighted*** rows that result in the most recent goals to keep. Thank you in advance. my table looks like this: Name. Goal. Date set Amt jeff. Prod sold. 1/1/2020. 10 jeff. Prod sold. 2/3/2020. 15*** steve. Cold calls. 2/15/2020. 6 Steve. Product sold. 2/7/2020 9*** steve. Cold calls. 3/12/202. 8***
Solved
wal808
6 years ago Place DAX Commands and Tips
1KViews
0likes
2Comments