Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
User | Count |
---|---|
83 | |
78 | |
62 | |
61 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |