Forum Discussion

pmcinnis's avatar
pmcinnis
Helper III
6 years ago

Need DAX script to count, using several criteria

I need the DAX script that will provide the results in the column "# of J results for chemical 'a' equal to or above guideline" in the table below titled 'Desired Output'. 'Desired Output' is produce...
Need Help
pmcinnis's avatar
pmcinnis
Helper III
6 years ago

I may not be able to use an outside file sharing service. When you say to type the data in text, do you mean straight into this reply box, using spaces and enter for formatting?

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

If you copy and paste it from Excel that should work, and yes just paste it in a reply. 

 

There should also be a table element in the ribbon, you can click that and paste into it as well.

 

 

  • pmcinnis's avatar
    pmcinnis
    Helper III
    6 years ago

    Power BI won't allow me to copy and paste from Excel into my forum post/reply. The table insert only allows 10x10 max, so that doesn't really work either. Might there be something I'm doing wrong?

     

     

     

     

     

     

    • pmcinnis's avatar
      pmcinnis
      Helper III
      6 years ago

      Power BI won't even allow me to enter data into a table in these forum posts. When I use the table insert icon, even if I just try 5x5, the data won't copy over to it from Excel. What am I missing?