Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BudMan512
Helper V
Helper V

Sales between Tuesdays and Fridays

Hi All,

I am working on a Matrix with columns for several different branches and their gallons sold for May.  The report needs the gallons delivered between each Tuesday and Friday. I have two issues I would appreciate help with.

First, the below screenshot contains each Tuesday and Friday of the month but I also need the gallons for the final days of the month which could be several days after the last Tuesday or Friday.   In May there was only one day left, Wednesday but other months vary.

Here is the DAX I have been trying to get beyond.

TUES-FRI =

CALCULATE([MTD Gallons],

FILTER('Calendar',

'Calendar'[Day of wk] = "TUE" || 'Calendar'[Day of wk]= "FRI"))

 

 

BudMan512_0-1688662938188.png

Secondly, I currently have the Month to Date gallons for each branch.  What I need is the gallons delivered between each Tues and Fri.  So in the May data, the first day tracked is Tuesday May 2. In this case I am able to use the MTD values.  But I would like help calculating the other values from  Friday May 5th and beyond.  There is an additional challange at the end of the month. I need the gallons from the final Tue/Friday to the last day of the month as well with total gallons for the month at the bottom.

Here is what I have for DAX so far for this.  

MTD Gallons =

CALCULATE(sumx(history,

History[QTY] * History[INV_MULTIPLIER]),

DATESMTD('Calendar'[Calendar]))

 

I have several hours of work into this but have not been able to get any further.  Any help would be appreciated.

Here is a screenshot of the model.

BudMan512_1-1688664868607.png

 

Thanks much,

Bud

 

1 REPLY 1
lbendlin
Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors