User Profile
eliele
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Is there a way in Power BI to sum all values in the column that come before an empty row?
Hey, I am trying to sum all values in column "Delta" (please see below) that come before the first empty row. Is there a way using DAX to do this? In other words, for the below data, I need a measure that calculates 2.1 + 3.5 + 7.7 + 1.2 = 14.5. ID Delta 1 2.1 2 3.5 3 7.7 4 1.2 5 6 5.8 7 1.0 8 9 4.5 10 6.8 11 12 2.1 13 14 Thank you!Solved814Views0likes2Comments- 32KViews0likes0Comments
Repetitive Indexing for certain IDs
Hey, Is there a way in Power BI to index a group of repetivie IDs? For example, below is an illustarive dataset with Date, City, and State. I want to be able to index every time Florida (FL) appears, but if the earlier City was also in FL, then I don't want the index to change. I included a column with the desired outcome. The reason I am asking this is because I want to be able to know if the location is currently in FL, and if it is in FL, how long it's been there. With the use of index, I can easily find the answer. If you think of a different solution, I would be more than happy to hear of an alternative answer rather than first indexing. Date City Sate Desired Outcome 5/22/2019 7:06 Miami FL 1 5/22/2019 5:23 Olrando FL 1 3/29/2019 2:28 Jacksonville FL 1 2/23/2019 9:05 Atlanta GA 2/23/2019 9:05 Los Angeles CA 2/20/2019 2:56 Miami FL 2 11/20/2018 9:54 St. Louis MO 11/19/2018 6:10 Los Angeles CA 8/21/2018 4:13 Orlando FL 3 5/29/2018 5:02 New York NY Thank you!Solved747Views0likes1CommentRe: Python Script Automatic Refresh
Hey Anonymous , All I do is data manipulation in Python. I import data from a database that with no problem automatically updates, and then do some data manipulation using python. I do not use python to import data - only to manipulate the current data. In terms of Gateway, it doesn't even give me an option to setup one like with R. If I manipulate data with R, the Dashboard gets automatically updated using the Gateway; if I use python, it doesn't. Below are the modules I use: import datetime from datetime import timezone import time import dateutil import calendar import pandas as pd Thank you!32KViews0likes5CommentsPower BI Matrix Calculated Column
I created the matrix below and I have page filters based on id and month. Is there a way for me to create a calculated column that does Failures/Flights? I tried creating it as an additional column on my data, but is not dynamic by months/ids filtered. Thank you!Solved2.4KViews0likes4Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.