Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am new and working the last 2 weeks on a projekt with Power BI.
I have different data from a system of a university. Is it possible to assign pre defined time periods (e.g. 1.10.2021 to 31.03.2021) a special name (WS20/21). I want to check this for the last six periods.
So each one of the different persiods is to be checked in the CREATE column and the NAME is to be inserted accordingly.
I need this to show the data for each semester of the university how specific activities developed.
Has someone an idea?
Cheers
Solved! Go to Solution.
@tacktick Ok, easy. You can't write first a string like the period name, and as if false a decimal numer. Try with "0", instead of 0.
B.
Thank you, on the first view, this might solve the problem, but I have the problem to get the different formates together.
If I use der notation with dots, it doesn't work, with DATE the following problem comes up. 😞 mabe yyou have also a solution for this?
@tacktick Check the column DATE type, it must be in Data Type: Date. Click on the column and then in the section Column Tools of the menù. The formula should then be correct.
B.
I made a new column and the type is DATE. Now the next error message came up.
@tacktick Ok, easy. You can't write first a string like the period name, and as if false a decimal numer. Try with "0", instead of 0.
B.
Hi @tacktick !
You can create a new column with some if conditions, like:
= IF ([date] >= 1.10.2021 && [date] <= 31.03.2021, "WS20/21", IF ([date] >= tot && [date]<= tot, "NAME_PERIOD", IF(.....)))
If this is not what you were looking for, I ask you to put some data and the result you expect, so as to better understand.
B.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
26 | |
20 | |
13 | |
8 |
User | Count |
---|---|
76 | |
48 | |
46 | |
20 | |
16 |