The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello Team,
I need to convert the qlik Expression to dax.
below is the Qlik Expression
if(Dimensionality()=3 and (Sum({$<CalendarDate={"$(=date(vMaxDate))"},[CusipTypeBK]={1,2,3}>} EndMV+EndAccrual)<>0) ,EXP(Sum(Aggr(Log(1+Sum({$<CalendarDate={">=$(=date(QuarterStart(max(CalendarDate))))<=$(=date(max(CalendarDate)))"},[CusipTypeBK]={1,2,3}>}Numerator)
/fabs(Sum({$<CalendarDate={">=$(=date(QuarterStart(max(CalendarDate))))<=$(=date(max(CalendarDate)))"},[CusipTypeBK]={1,2,3}>}Denominator))),CalendarDate,Cusip_Description)))-1
,null()
@7026328380 , if you can share the logic of what you need, it might be easy. Please share the logic of what you need
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |