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.
Hi Experts,
Please hava a look, Is it possible to convert the bellow formula into DAX,
=IF(B44>=TODAY(),G43,IFERROR((((M44+SUM(C45:C$74))*180)-Q44)/SUM(C45:C$74),NA()))
Regards,
Salem sabir
Hi @Anonymous
Yes it is possible, but if you want us to do it, we will need a sample of your data, column name / table name and expected result
Here's a guide on how to ask a question :
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Else, you can do it by using TODAY() and DATE() function and replacing your cell names by column name.
Quentin
Hi Quentin https://community.powerbi.com/t5/user/viewprofilepage/user-id/62225,
Please find bellow snap of the data and expected result.
The formula is in cell: G44
Regards,
SalemSabirK
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 |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
105 | |
104 | |
89 | |
65 |