This is something very interesting,
We can to create a table that is called calendar in power bi. Now do we do that?
Yes, you are write, we will DAX.
))
Notice: we moved to https://sihan.hashnode.dev/
This is something very interesting,
We can to create a table that is called calendar in power bi. Now do we do that?
Yes, you are write, we will DAX.
))
Database table partitioning in SQL Server (sqlshack.com)
On this link, I came across one of the best tutorials for partitioning concept.
This code will filter the rows where the 'Year' column is 2017 and select only the 'Year' and 'Revenue (GBP Millions)' columns. It will print the filtered rows with the corresponding values for both columns.
Make sure to replace 'Year'
and 'Revenue (GBP Millions)'
with the actual column names in your dataframe. If you have more columns that you want to include in the filtered result, you can add them within the double square brackets, separated by commas.
Note: If you want to perform any calculations or further data analysis on the filtered data, it's recommended to assign it to a new variable, like filtered_data
, rather than modifying the original dataframe directly.
filtered_data = df[df['Year'] == 2017][['Year', 'Revenue (GBP Millions)']]
print(filtered_data)