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.
I am new to Power BI and I am looking for the following solution:
I have a table with Date and Status
Example
Date Status
Dec-01-2010 Accepted
Jan-01-2011 Accepted
Jan-02-2011 Decline
Jan-03-2011 Accepted
Feb-01-2011 Accepted
Feb-02-2011 Decline
Mar-01-2012 Decline
I need to get the following result:
You can see that I only need the data with DATEBETWEEN Jan-01-2011 to Feb-02-2011.
Month #Total_Status #Accepted
Jan11 3 2
Feb11 2 1
Looks like I can use a New Messure to calculate by month the total number of Status and the total number of Accepted under status but needs to be only with the days between
Solved! Go to Solution.
Hi @TiaCamilian ,
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
# of Accepted = var MinDate = MIN('Table'[Date]) var MaxDate = MAX('Table'[Date]) var CountStatus = CALCULATE(Counta('Table'[Status]),FILTER(All('Table'),'Table'[Date]>MinDate && 'Table'[Date]<MaxDate),'Table'[Status]="Accepted") return CountStatus ---------------------------------------- # of Status = var MinDate = MIN('Table'[Date]) var MaxDate = MAX('Table'[Date]) var CountStatus = CALCULATE(Counta('Table'[Status]),FILTER(All('Table'),'Table'[Date]>MinDate && 'Table'[Date]<MaxDate)) return CountStatus
Proud to be a Super User!
Hi @TiaCamilian ,
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
# of Accepted = var MinDate = MIN('Table'[Date]) var MaxDate = MAX('Table'[Date]) var CountStatus = CALCULATE(Counta('Table'[Status]),FILTER(All('Table'),'Table'[Date]>MinDate && 'Table'[Date]<MaxDate),'Table'[Status]="Accepted") return CountStatus ---------------------------------------- # of Status = var MinDate = MIN('Table'[Date]) var MaxDate = MAX('Table'[Date]) var CountStatus = CALCULATE(Counta('Table'[Status]),FILTER(All('Table'),'Table'[Date]>MinDate && 'Table'[Date]<MaxDate)) return CountStatus
Proud to be a Super User!
Thank you for your help.
Do I create a new table or messure for your example.
Sorry I am new at this
Hi @TiaCamilian ,
Here is my pbix, Number accepted I didn't create a new table, just used your data. Did create two new measures. You should be able to put your table and column names into my example and have it work.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Thank you for the solution and is working well
How do we tell that "You can see that I only need the data with DATEBETWEEN Jan-01-2011 to Feb-02-2011"?
Nathaniel
Proud to be a Super User!
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |