Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi everyone, I am first timer here with my query, and I am stuck with below issue. Here my measure "Cumulative DefScheduledQty" is calculated wrong. I am using below formulas. Kindly suggest
DefSchedulesQty =
if(ISBLANK(sum(DefaultSchedules[Qty])), sum(schedule[BilledHours]), sum(DefaultSchedules[Qty]))
Cumulative DefSchedulesQty =
Var selectedDate = SelectedValue(DimDate[date])
Var Years = YEAR(selectedDate)
Return
Calculate( [DefSchedulesQty],Filter(ALLSELECTED(DimDate),DimDate[date]<=selectedDate))
Please take a look at:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 6 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |