Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@Anonymous 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?
@Anonymous 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.
@Anonymous 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 @Anonymous !
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.
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |