Forum Discussion
Formula with Cell reference in DAX
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
2 Replies
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
