Reference Columns in a Virtual Table in other function

Question

I need to first group by my data by date and then calculate second quartile. I used the function SUMMARIZE() But I cannot refer the virtual table column as an argument in the PERCENTILE.INC() and gives below error

`

MyPercntile= 
var tbl_group=SUMMARIZE(site,site[تاريخ],"summm",
CALCULATE(sum(site[حجم معامله به تن]))
)

var bb=PERCENTILE.INC(tbl_group[summm],0.2)
return 
bb

error is Table variable 'tbl_group' cannot be used in current context because a base table is expected.

What should be done for functions that only have to pass columns?

Is this no longer solved?

davidebacci
– davidebacci

2024-09-11 20:28:07 +00:00
Commented Sep 11, 2024 at 20:28 — davidebacci
– davidebacci, Commented Sep 11, 2024 at 20:28

davidebacci · Accepted Answer · 2024-09-09 07:49:25Z

0

Use the iterator function instead (with an X on the end).

PERCENTILEX.EXC

https://dax.guide/percentilex-exc/

answered Sep 9, 2024 at 7:49

davidebacci

31.4k4 gold badges20 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reference Columns in a Virtual Table in other function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related