topic Re: Need help with DAX Formula, please in DAX Commands and Tips

Need help with DAX Formula, please

Dallas7890 — Fri, 03 Mar 2023 16:08:06 GMT

Hello,

I am trying to figure out how to write the same DAX formula that I have here in Excel.

I have 8 Network feeds, and I am trying to figure out the Perfect amount of seconds in DAX, as I show here in Excel.

Show a card with 108518400 in Seconds.

and show another card with 99.666% perfect availability

To calculate 13564800

To Calculate 108518400

or to calculate the

Re: Need help with DAX Formula, please

andhiii079845 — Fri, 03 Mar 2023 19:03:55 GMT

Please show your table in PBI.

Re: Need help with DAX Formula, please

Dallas7890 — Sat, 04 Mar 2023 15:55:58 GMT

Hello

These are my PBI tables and the excel sheet that has the formula for Total perfect seconds (per day) for my 8 Network List and the formulas that I am trying to recreate in Power BI DAX to match the same. This is the January 2023 example.

This is another example for February

If I knew how to attach my Excel file and PBIX I would, but I can't seem to be able to do that here. Please let me know if there is anything else I need to show.

Re: Need help with DAX Formula, please

andhiii079845 — Thu, 09 Mar 2023 19:58:46 GMT

You can upload it via ondrive or dropbox. 🙂

Re: Need help with DAX Formula, please

Dallas7890 — Thu, 09 Mar 2023 20:10:19 GMT

Thanks, good to know that I can upload my file using OneDrive. I will do that next time. I am all good for now, and I have a resolution.