Forum Discussion
Dicken
Post Prodigy
Post ProdigyDAX index Function how to use?
Hi, I have not used index in dax pbi, but thouhgt I'd have a look, so created a date table ; dDate =
ADDCOLUMNS(
CALENDAR( DATE( 2020,1,1), DATE( 2025,12,31) ) ,
"Year", YEAR([Date]),
"...
Dicken , I created a table with the same code, and it worked
In case of measure use
Maxx( INDEX(1 , dDate, ORDERBY(dDate[Date]) ), [Date])
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Dicken Try this :
use distinct around the table you are using in window functions
let me know if this works
DickenPost Prodigy
Post ProdigySo does it return a table, as that's what I was using;
New Table,
Table = INDEX(1, dDate, ORDERBY(dDate[Date],ASC)
out of interest I get the same message for window.
Table 2 = WINDOW( 1,ABS,1,ABS,dDate ) again I get duplicate error message,
so still none the wiser as to how it works,
i thought I'd try a simpler date table ;
dDate = ADDCOLUMNS(
CALENDAR( DATE( 2020,1,1), DATE(2020,12,31) ),
"Year", YEAR([Date]),
"Month", FORMAT([Date],"MMM")
)
and put this into studio, but get message, an item with the saem key has already been added?
Don't have these problems in power pivot.
Richard
Don't have these problems in power pivot.
Richard
Daniel29195
Community Champion
Community ChampionDicken Try this :
use distinct around the table you are using in window functions
let me know if this works
- Dicken
Thanks,
RD