Forum Discussion

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Creating IF Statement Over Category

Hello All,   I am running into an issue trying to write a measure/calc. column which is basically an IF statement that classifies items:   Classification = IF([Sum] < 5000000 , "<$5M", IF([Sum] ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

nirvana_moksh's avatar
nirvana_moksh
Icon for Impactful Individual rankImpactful Individual
7 years ago

Ashish_Mathur - Here is the link to the file which contains the sample data with few details listing out the issues which you can download. This has been so annoying, I feel I am missing something very basic here. Thanks a lot in advance Ashish! 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • nirvana_moksh's avatar
    nirvana_moksh
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Like always thanks for the wonderful help Ashish_Mathur! This worked :)

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      You are welcome.