Forum Discussion

o59393's avatar
o59393
Post Prodigy
6 years ago
Solved

Nested IF DAX

Hi all   I need to have an if formula that returns me a value from one column (Weight in this case) based on the date ranges (start date and end date).     In the example above, on the rig...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

o59393's avatar
o59393
Post Prodigy
6 years ago

Hi amitchandak 

 

So I should go from:

 

Measure 2 = CALCULATE(sumx(SUMMARIZE(filter(CROSSJOIN(Sheet1,'Date'),'Date'[Date]>=(Sheet1[Start Date]) && 'Date'[Date]<=(Sheet1[End Date])),Sheet1[Contract],'Date'[Date],"_sum",sum(Sheet1[Daily Value])),[_sum]))
 
to
 
Measure 2 = CALCULATE(sumx(SUMMARIZE(filter(CROSSJOIN(Sheet1,'Date'),'Date'[Date]>=(Sheet1[Start Date]) && 'Date'[Date]<=(Sheet1[End Date])),Sheet1[Contract],'Date'[Date], ... 
 
I get lost in the final part.
 
Thanks.