Equivalent Function between Qlik and PowerBI

Question

I am doing migration report from Qlik to PowerBI.

I am wondering how to change this Qlik function into PowerBi.

=Num(Count(distinct {1 <[Type]-='Other',SaleDate=P(MasterCalenderDate)> } [CustomerId]) , '###,###,####')

Any help ?

Could you pls provide some sample data and expected output?

Ryan
– Ryan

2024-09-11 00:05:00 +00:00
Commented Sep 11, 2024 at 0:05 — Ryan
– Ryan, Commented Sep 11, 2024 at 0:05

user9517769 · Accepted Answer · 2024-09-11 18:02:31Z

0

I understood that you want to count distinct CustomerId where the type is different from 'Other' and where the SaleDate matches the MasterCalendarDate :

NumCustomers = 
FORMAT(
    COUNTROWS(
        FILTER(
            ALL(CustomerTable), 
            CustomerTable[Type] <> "Other" && 
            CustomerTable[SaleDate] IN VALUES(MasterCalendar[MasterCalendarDate])
        )
    ), 
    "###,###,####"
)

answered Sep 11, 2024 at 18:02

user9517769

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

Collectives™ on Stack Overflow

Equivalent Function between Qlik and PowerBI

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