I am new to DAX could you please help me convert below written Formula in Excel Workbook to DAX. (as we are migrating to Power BI). I am also attaching sample Excel File and the formula that needs conversion to DAX is written in Column L. (Just place your cursor on cell L10 to see the formula in the top formual bar within Excel File)
I provide the details for referenced dates used in below excel formaula
PlanStart = 08/12/2018
Plan Finish = 04/01/2019
Here is the formula written in Excel Workbook
=IF( AND( MAX( E258, F258 ) <= PlanFinish, MIN( E258, F258 ) >= PlanStart ), COUNT( E258:F258 ), IF( AND( E258 >= PlanStart, E258 <= PlanFinish ), 1, IF( AND( F258 >= PlanStart, F258 <= PlanFinish ), 1, 0 ) ) )
Just to let you know that, I cannot attach excel or CSV file as an attachment, when I try to do it, the forum says (Incorrect File Type). I have given a try to both type of files (Excel and CSV) Please let me know if you guys need further understanding on converting this formual to DAX.
Please upload your file to One Drive and share the link here.
Please find below link to the excel file on one drive
I cannot access the file you shared, could you please share it again?
Hi @smjzahid ,
Dropbox is also fine.