Formula with Cell reference in DAX

[Anonymous]

 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

[quentin_vigne]

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

[Anonymous]

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