Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 9 | |
| 6 | |
| 5 |
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 19 | |
| 17 | |
| 11 |