Forum Discussion
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
To calculate 13564800
To Calculate 108518400
or to calculate the
Please show your table in PBI.
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.
You can upload it via ondrive or dropbox. 🙂
4 Replies
Please show your table in PBI.
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.
You can upload it via ondrive or dropbox. 🙂
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.