Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Please refer to below snapshot and syntax of Y3 cell from Excel File, i am looking for equivalent DAX syntax to get similar output in Power BI.
Please review and suggest.
Thanks.,
Pradeep
Solved! Go to Solution.
in calculated column, this code might work =minx(filter(table,table[system name]=earlier(table[system name])&&table[mulfunction end date]>earlier(table[mulfunction end date])),table[mulfunction end date])
@PradeepVarma it could be
=averagex(filter(table,table[system name]=earlier(table[system name])),table[day between next brk])
in calculated column, this code might work =minx(filter(table,table[system name]=earlier(table[system name])&&table[mulfunction end date]>earlier(table[mulfunction end date])),table[mulfunction end date])
Can you suggest syntax in DAX for below Excel formula
@PradeepVarma it could be
=averagex(filter(table,table[system name]=earlier(table[system name])),table[day between next brk])
Great .. Appreciate your support
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
46 | |
31 | |
30 | |
18 | |
18 |