Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with DAX

Hi Team ,   I am facing issue with the below mentioned DAX formula   CYCQCW-Win Rev = IF(and(AND([Fcst]="CQ",OR([SS_No]="07",[SS_No]="08")),[WEEK_NUM]= MAX(IF( [Fcst]="CQ",[WEEK_NUM],BLANK...
  • HotChilli's avatar
    HotChilli
    4 years ago

    I wasn't quite sure what you wanted as a result (500 on every CQ? or a measure?)

    Anyway here's a column:

    ColumnX = var _fcst = TableA[FCST]
RETURN
IF (_fcst = "CQ",
CALCULATE(SUM(TableA[REVENUE]), 
    FILTER(TableA, TableA[WEEK] = 4 && TableA[STAGE] IN {"07", "08"} && TableA[FCST] = _fcst)))

    If it's not quite what is required at least you can edit it for desired result

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

I provided code for a column. I think you are creating a measure. That's OK but you'll need to make some changes.