Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Use COUNT functions over rows

Hey,   I can not wrap my head around on how to put the following Excel Formula in Power BI. The goal is to perform this calculation for each row in the Table (#rows =~200).   (COUNTBLANK(C2:GT2)/...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download the PBI file from here.

    Hope this helps.

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Can you share a sample of your data and how it organized? is it in columns or rows in Power BI ?


  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    It is in columns in Power BI, I have tried to pivot the columns but to no avail. This is the data set and expected outcome I am working with: Dataset Link 

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      5 years ago

      Anonymous 

      please see the attachment below. hopt it's helpful.

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      Hi,

      You may download the PBI file from here.

      Hope this helps.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks that worked. I had tried this solution before but apparently my data model was not set correctly to receive the expected outcome.