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 together, maybe an expert can help me?
Whats wrong in this code:
Solved! Go to Solution.
@Tober1996 , This should be like
Result = IF((Table1[Site]="Memphis" || Table1[Site]="York") && (Table1[EndDate])<Date(2021,1,1), 0,Table1[Benefit1]+Table1[Benefit2])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hello amichandak, thanks for your help. It's the same as my first version. I don't know why it works now. Most of the time, the fault is in front of the device.
Thanks again!
@Tober1996 , This should be like
Result = IF((Table1[Site]="Memphis" || Table1[Site]="York") && (Table1[EndDate])<Date(2021,1,1), 0,Table1[Benefit1]+Table1[Benefit2])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |