๋ฐ์ํ
Index = (COUNTROWS(TABLE_NAME) - RANKX(ALL('TABLE_NAME'), [COL_NM]))+1
Creating an Index Column for a Descriptive Data Using "DAX" in Power BI
I have a table Like this, Table1 ColA ColB Orange Apple Mango Not Apple Mango Not Apple I want to create a column called as RowNumber using DAX and not Query Editor (M). So the Expected out...
stackoverflow.com
๋ฐ์ํ
'Power BI > DAX' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [Power BI] DAX - CALCULATE (0) | 2021.02.23 |
|---|---|
| [Power BI] DAX - Dynamic Index (0) | 2020.09.01 |
| [Power BI] DAX - The GENERATESERIES function (0) | 2019.08.07 |
| [Power BI] DAX - DATATABLE ํจ์๋ก Static table ๋ง๋ค๊ธฐ (0) | 2019.08.07 |
| [Power BI] DAX - SUMMARIZE + UNION ํ ์ด๋ธ ๊ฒฐํฉ (0) | 2019.08.07 |