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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Nir0
New Member

Adding One-off cost to a Rolling Cost Measure

Hi,

 

I am currently trying to figure out a way to add a one-off cost to a rolling cost measure.

 

To give a better idea: Vehicle Hire

It will have a daily hire cost, but some times you may be charged a one-off cost (ie. installation fee).

 

I have created a measure where it calculates the Year to Date cost and also Monthly Cost, which changes accordingly to a date slicer, but everytime I try to add the one-off cost, it does not return the correct figure.

 

I've also just tested out to see if the one off cost comes up correctly which it does, does anyone know of a way which I can get it to work?

 

Thanks

 

 

1 REPLY 1
Anonymous
Not applicable

Please give some sample data, table, images. It would help also if you tried to explain the logic of this measure in DAX-like terms, even if incorrect, this will help us understand the desired funcitonality. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.