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 

 

I see you use count x, but in my case is not a count of cases. Is pretty much return a value based on the date ranges.

 

Appreciate you help!

 

    • 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.