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 all, I am a complete newbe to PowerBI.
I have a table with 3 columns, the first one is "id file" each name is different, the second is the date of creation for each of this files,the third one is the date of cloture.
i'd like to make a bar chart that shows by month the number of files created (one bar) and the number of files finished (second bar)
thanks, and sorry for my english
Solved! Go to Solution.
@PTIFANOU OK:
Creation Month = FORMAT([CreationDate],"mmmm")
Cloture Month = FORMAT([ClotureDaate],"mmmm")
Documents Created =
VAR __Month = MAX('Months',[Month])
RETURN
COUNTROWS(FILTER('Table',[Creation Month] = __Month))
Documents Cloture =
VAR __Month = MAX('Months',[Month])
RETURN
COUNTROWS(FILTER('Table',[Cloture Month] = __Month))
Hi,
I suggest having a calendar table like below.
One active relationship and one inactive relationship.
And then use USERELATIONSHIP dax function when using inactive relationship.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I suggest having a calendar table like below.
One active relationship and one inactive relationship.
And then use USERELATIONSHIP dax function when using inactive relationship.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@PTIFANOU OK:
Creation Month = FORMAT([CreationDate],"mmmm")
Cloture Month = FORMAT([ClotureDaate],"mmmm")
Documents Created =
VAR __Month = MAX('Months',[Month])
RETURN
COUNTROWS(FILTER('Table',[Creation Month] = __Month))
Documents Cloture =
VAR __Month = MAX('Months',[Month])
RETURN
COUNTROWS(FILTER('Table',[Cloture Month] = __Month))
thanks a lot both of yours solutions works perfectly
thanks fotr ur time and efforts
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |