Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI All
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 ) ) )
Please find below link to the excel file on one drive
Hi @smjzahid,
I cannot access the file you shared, could you please share it again?
Regards,
Frank
I cannot share the access level as it is a one drive for business account. Is there a different way through which it can be shared please
Thanks
Hi @smjzahid ,
Dropbox is also fine.
Regards,
Frank
Hello
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.
Many Thanks.....
Hi @smjzahid,
Please upload your file to One Drive and share the link here.
Regards,
Frank
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |