Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]),MAX(PMS_FINANCIAL_PDS[FISCAL_MON_END_DT])),DAY([Date]) =1), "CountComplaints", CALCULATE(COUNTROWS(PMS_COMPLAINT), FILTER(PMS_COMPLAINT,PMS_COMPLAINT[Fiscal_Mnth_Start_Date].[Year] = YEAR(EARLIER([Date])) && PMS_COMPLAINT[Fiscal_Mnth_Start_Date].[MonthNo] = MONTH(EARLIER([Date]))))+0),"__Index",RANKX(PMS_COMPLAINT,PMS_COMPLAINT[Fiscal_Mnth_Start_Date],,,Dense))
Solved! Go to Solution.
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 () )
Hi @Anonymous ,
Do you have some sample data or preferably a sample pbix file?
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 () )
can you upload a sample with your expect outcome? I'm pretty sure at least some of the error has to do with
Table 2 = ADDCOLUMNS ( ADDCOLUMNS ( FILTER ( CALENDAR ( MIN ( PMS_FINANCIAL_PDS[FISCAL_MON_START_DT] ), MAX ( PMS_FINANCIAL_PDS[FISCAL_MON_END_DT] ) ), DAY ( [Date] ) = 1 ), "CountComplaints", CALCULATE ( COUNTROWS ( PMS_COMPLAINT ), FILTER ( PMS_COMPLAINT, PMS_COMPLAINT[Fiscal_Mnth_Start_Date].[Year] = YEAR ( EARLIER ( [Date] ) ) && PMS_COMPLAINT[Fiscal_Mnth_Start_Date].[MonthNo] = MONTH ( EARLIER ( [Date] ) ) ) ) + 0 ), "__Index", RANKX ( PMS_COMPLAINT, PMS_COMPLAINT[Fiscal_Mnth_Start_Date],,, DENSE ) )
Hi Nick
The expected end results need to be... see image
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |