Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Addcolumns DAX formula error

Hi Experts   cannot see the wood for the trees, i just want to rank my values based on the data column. Table 2 = ADDCOLUMNS(ADDCOLUMNS(FILTER(CALENDAR(MIN(PMS_FINANCIAL_PDS[FISCAL_MON_START_DT]),...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Microsoft Team i have managed to solve said solution

     

    VAR Mytable1 = FILTER(ADDCOLUMNS(VALUES(PMS_FINANCIAL_PDS[Month Start]),"CountComplaints", CALCULATE(COUNTROWS(PMS_COMPLAINT)),"__Index",RANKX(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start],,,Dense )),[Month Start] <> BLANK ()
)
v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi Anonymous ,

 

Do you have some sample data or preferably a sample pbix file?

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Microsoft Team i have managed to solve said solution

 

VAR Mytable1 = FILTER(ADDCOLUMNS(VALUES(PMS_FINANCIAL_PDS[Month Start]),"CountComplaints", CALCULATE(COUNTROWS(PMS_COMPLAINT)),"__Index",RANKX(PMS_FINANCIAL_PDS,PMS_FINANCIAL_PDS[Month Start],,,Dense )),[Month Start] <> BLANK ()
)