Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dallas7890
Helper I
Helper I

Need help with DAX Formula, please

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

 

 

Dallas7890_3-1677858331588.png

Dallas7890_2-1677858308040.png

 

To calculate 13564800

Dallas7890_5-1677858387494.png

 

Dallas7890_4-1677858367119.png

 

 

To Calculate 108518400

Dallas7890_6-1677858453296.png

 

 

or to calculate the 

Dallas7890_8-1677858509834.png

 

Dallas7890_7-1677858475413.png

 

 

Dallas7890_1-1677858279016.png

 

Dallas7890_0-1677858226981.png

 

 



3 ACCEPTED SOLUTIONS
andhiii079845
Super User
Super User

Please show your table in PBI. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Dallas7890
Helper I
Helper I

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.

Dallas7890_0-1677945267242.png

 

This is another example for February

Dallas7890_1-1677945338656.png

 



 

 

 

 

 

Dallas7890_2-1677935768410.png

 

 

 

Dallas7890_0-1677935668889.pngDallas7890_1-1677935691332.png

Dallas7890_3-1677935809350.png

Dallas7890_4-1677935849101.pngDallas7890_5-1677935875078.png

Dallas7890_0-1677943947085.png

 

Dallas7890_1-1677944218279.png

Dallas7890_2-1677944283809.png

 

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. 

View solution in original post

You can upload it via ondrive or dropbox. 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Dallas7890
Helper I
Helper I

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
Helper I
Helper I

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.

Dallas7890_0-1677945267242.png

 

This is another example for February

Dallas7890_1-1677945338656.png

 



 

 

 

 

 

Dallas7890_2-1677935768410.png

 

 

 

Dallas7890_0-1677935668889.pngDallas7890_1-1677935691332.png

Dallas7890_3-1677935809350.png

Dallas7890_4-1677935849101.pngDallas7890_5-1677935875078.png

Dallas7890_0-1677943947085.png

 

Dallas7890_1-1677944218279.png

Dallas7890_2-1677944283809.png

 

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. 

You can upload it via ondrive or dropbox. 🙂





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




andhiii079845
Super User
Super User

Please show your table in PBI. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors