Forum Discussion

soumitra_mukh's avatar
soumitra_mukh
New Member
5 years ago

DAX command not returning a value

Hi I am not able to get any value retuned for the dax command below 
I am trying to calculate the last qtr cart adds based on selection however since my data has duplicates i have to summarise the data can some one please help me undersatdn the error with the formula 
 
I am fairly new to the community and this is my firt post so please bear with me in case i have missed anything
 
LQ_cartadd = Var _SelectedQtr=SELECTEDVALUE(DM_campaign_processed[Index]) Return CALCULATE(sumx(SUMMARIZE(
DM_campaign_processed,
DM_campaign_processed[JumpID],
DM_campaign_processed[Date],DM_campaign_processed[Cartadd]
),
DM_campaign_processed[Cartadd]),FILTER(DM_campaign_processed,DM_campaign_processed[Fiscal_YearQtr]=_SelectedQtr-1)
)

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    soumitra_mukh 

    I am not sure you have a dates table in your model, if not add a dates table and create relationships then use PREVIOUSQUARTER function to get the correct values.

    If you need further help, add some data to an Excel file along with expected results and share here using Google Drive or One Drive link.