Forum Discussion

RCSmart01's avatar
RCSmart01
Frequent Visitor
8 years ago
Solved

SumProduct in measure

i am fairly new to this and i created a "dashboard" in excel but know i want to learn how to put it in power bi, i ahve everything else i just need help on this last one.i am creating an "index" in e...
Need Help
  • RCSmart01's avatar
    RCSmart01
    8 years ago

    no but i got exactly what i want going through the query editor, didn't even have to use index or custom columns! Thanlks for all your help and i apologize for wasting your time on trying to help me.

RCSmart01's avatar
RCSmart01
Frequent Visitor
8 years ago

can i use the ranking function to get what i want?

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
8 years ago

I used ranking based on measure like revenues ( sum of revenue), etc...

 

I used to add index in Power Query by doint a partition of the table.

Are you familiar with Power Query?

 

Otherwise other members could help you with Dax formula.

 

Ninter

  • RCSmart01's avatar
    RCSmart01
    Frequent Visitor
    8 years ago

    no but i got exactly what i want going through the query editor, didn't even have to use index or custom columns! Thanlks for all your help and i apologize for wasting your time on trying to help me.

  • Interkoubess's avatar
    Interkoubess
    Icon for Solution Sage rankSolution Sage
    8 years ago

    hi RCSmart01,

     

    Please mark your solution and close this subject.

     

    With pleasure we are here to help...

     

    Ninter