Need help with DAX Formula, please

[Dallas7890]

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 

[andhiii079845 · Accepted solution]

Please show your table in PBI. 

[Dallas7890 · Accepted solution]

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. 

[Dallas7890]

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.

[Dallas7890 · Accepted solution]

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. 

[andhiii079845 · Accepted solution]

You can upload it via ondrive or dropbox. 🙂

[andhiii079845 · Accepted solution]

Please show your table in PBI.