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 Ashish_Mathur 

 

I attach my PBIx using (or trying to use) your steps. In the table dashboard, you will see It is repeating each of the days 3 times.

 

Also I noticed you removed the end and start date from the query, I need those dates to be visible in my dahsboard for people to see it.

 

Can you help me?

 

https://1drv.ms/u/s!ApgeWwGTKtFdhjb-8R5LAVb1Amnk

 

Thanks

 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

I am confused over what you want.  Share a simple dataset and show me the exact result you want.  Please realise that it takes a lot of my time to answer your question so please respect my time and effort and state the question and expected result very clearly.  Review your question time and again before posting - that is the very least i can expect of you.

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    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 Ashish_Mathur 

     

    Apologies for the confusion.

     

    Here is the excel with the desired solution. You will see colors blue, green and yellow that distinguish the values based on the dates.

     

    https://1drv.ms/x/s!ApgeWwGTKtFdhjcOMqI6H9v620Lg?e=sAOzy5

     

    Please do not remove the original columns start and end date with Power Query,

     

    Hope this clarifies.

     

    Regards.

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You have shared the expected result.  Now share the original data also in an Excel file.

     

  • o59393's avatar
    o59393
    Post Prodigy
    6 years ago

    Thank you very much Ashish_Mathur 

     

    It worked very well.

     

    Apologies once again for not being clear from the start.

     

    Regards. 

     

     

     

     

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    6 years ago

    You are welcome.  No problem.