Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Dax command showing different answer in chartBar

Hello Everyone, I have written DAX command as mentioned below to get the running sum based on the year month but for the month Jan I need to add constant value and then each month internal and ext...
music43's avatar
music43
Advocate II
2 years ago

Hi

Can you simplify your DAX to something along these lines

Actual_Incoming =
var yearval = SELECTEDVALUE(Date[year])
var monthnum = max( Date[month] ) -- use the month number column
var BusinessM = SELECTEDVALUE(Orderbook[BusinessM])

var Result = [CurrentOrder_internal] + 
    CALCULATE(
        ([Incoming_Internal] - [Delivery_Internal]),
        ( isblank(BusinessM) ||'Orderbook'[BusinessM] = businessm ) ,
        'Date'[MonthName] <= monthnum ,
        Date[year] = yearval 
)

RETURN
    Result

If nothing else, it might make debugging easier for you.