Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
7026328380
Frequent Visitor

Need to convert Qlik expression to DAX

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()

 

@dax @PowwerBI @BIHelp 

1 REPLY 1
amitchandak
Super User
Super User

@7026328380 , if you can share the logic of what you need, it might be easy. Please share the logic of what you need

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.