The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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!
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
34 | |
13 | |
12 | |
9 | |
7 |