Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
Can anyone please help me to replicate below Qlik Script in PBI
Sum
(
{
<
[Recon Part Flag]={'N'},
DATA_TYPE={'PARTS'},
[Manufacturer Supplier]=P({<[Recon Part Flag]={'Y'}>}[Manufacturer Supplier])
>
}
[Duty and Fees Amount])
Thanks in advance!!
Solved! Go to Solution.
Hi @Bharathi_99 ,
My Qlik formula skill is a bit rusty, but according to Chat GPT your qlik formula is converted into the following dax formula.
Best regards,
Hi @Bharathi_99
In Power BI, you have to put the name of the table as well as column reference for the filtering and I am not sure what are your table names for the field reference. I suppose the above Qlik formula is filtering the measure [Duty and Fees Amount] from various columns in the data model. I hope you will find Power BI formula to be so much simpler than curly brackets you have to write to do filterings in Qlik.
Best regards,
Table name is fact
Column names are same
Hi @Bharathi_99 ,
My Qlik formula skill is a bit rusty, but according to Chat GPT your qlik formula is converted into the following dax formula.
Best regards,
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
189 | |
94 | |
67 | |
63 | |
56 |