topic Weekend Volume Criteria in DAX Commands and Tips

Weekend Volume Criteria

HALEYSTODDARD — Tue, 04 Oct 2022 19:13:49 GMT

Hello,

I'm trying to come up with a formula that essentially adds Saturday volumes less than 100 units to Friday's totals, else if volumes exceed 100 units then keep volumes under saturday.

For example, I need 9/3 to be added to 9/2 since it's just volumes that were completed right after midnight.

However here, I would need it to stay under this Saturday date (8/20) since significant volume was processed.

Re: Weekend Volume Criteria

Greg_Deckler — Tue, 04 Oct 2022 19:32:28 GMT

HALEYSTODDARD What does your source data look like? Can you post as text? Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: Weekend Volume Criteria

jgeddes — Tue, 04 Oct 2022 19:56:17 GMT

I took a crack at this creating a dataset of volume of items per date.

My understanding of your request is that if the total Saturday volume is less than 100 then the item volumes are added to Friday and Saturday is then 0. If the volume is 100 or greater on Saturday then the item volumes are left as is.
To get the desired result I created a calculated column in the table.

And ended up with the result

Hope this gets you pointed in the right direction.