Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
I am having a challenge replicating Power BI (DAX) measure to Qlik sense Measure and I am having an issue,
The DAX measure I am trying to replicate:
ABN FY20 Daily Incidents = (CALCULATE('ABN Incidents Combined'[IncCountABN], 'FiscalMnthTable'[FY] = "FY20"))/DATEDIFF("01-Oct-2019", TODAY(), DAY)
The Qlik Sense measures i got so far:
1. Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00')
2. Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')
How I got the above:
DAX- IncCountABN = COUNTA([Incident Number])+0
Qlik -Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')
Then
DAX- ABN FY20 Incidents = (CALCULATE('ABN Incidents Combined'[IncCountABN], 'FiscalMnthTable'[FY] = "FY20"))
Qlik - 1. Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00')
2. Num(Count({<Source={'ABN'}>} Incident_Number),'##.00')
What I am trying to achieve is to combine the above measures (Qlik 1 &2) and get daily number which so far seems very challenging. Anyone who has DAX and Qlik would be awesome . Thanks in advance
I think I got it:
(Num(Count({<FYear_Num={$(=Max(FYear_Num))}>} Incident_Number)/1, '##.00')/(date(today(),'DD/MM/YYYY')-'01/10/2019'))/
(Num(Count({<FYear_Num={$(=Max(FYear_Num)-1)}>} Incident_Number)/1, '##.00')/365)