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.
Hello,
I have three tables and these three tables are linked to a TABLE CALENDAR.
Solved! Go to Solution.
Hi,
and thank you again for your response!
Table A
-----------
ID Close_Date(in type string)
1 1/02/2018
2 1/05/2018
3 15/06/2018
4 empty
5 empty
6 18/06/2018
7 1/05/2018
8 15/06/2018
9 01/03/2019
10 15/03/2019
11 01/04/2019
12 20/02/2019
13 empty
14 empty
My open date table is also of type string, what I did was create a calculate column that reads from the table open the text and convert to date, so I can connect to my calendar table.
To then be able to put all my measures in a MATRIX visual in which they share all the same date column.
My goal is to calculate how many rows were open at the end of each desired date, then calculate how many were open at the end of each day or at the end of each month (no close state)
For example:
JANUARY 2018 -> 2
MARCH 2018 -> 5 (not only the two that were opened in March but the totality that were open at the end of March, without a closed date in March 2018)
I use a MATRIX VISUAL not a table visual.
Can you give me a hand? Really grateful.
Best Regards,
JO
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Thanks for the quick response,
but I tried to see the two suggestions that you sent me and I tried to understand, but I can not understand how I will fit those DAX functions into my DAX function because I'm still very new to DAX function.
Could someone help me?
Best Regards
Can you just do a Merge query and then your table should basically be like the one in Open Ticket.s Otherwise, share your Close table like you did your Open table with the expected results.
Hi,
and thank you again for your response!
Table A
-----------
ID Close_Date(in type string)
1 1/02/2018
2 1/05/2018
3 15/06/2018
4 empty
5 empty
6 18/06/2018
7 1/05/2018
8 15/06/2018
9 01/03/2019
10 15/03/2019
11 01/04/2019
12 20/02/2019
13 empty
14 empty
My open date table is also of type string, what I did was create a calculate column that reads from the table open the text and convert to date, so I can connect to my calendar table.
To then be able to put all my measures in a MATRIX visual in which they share all the same date column.
My goal is to calculate how many rows were open at the end of each desired date, then calculate how many were open at the end of each day or at the end of each month (no close state)
For example:
JANUARY 2018 -> 2
MARCH 2018 -> 5 (not only the two that were opened in March but the totality that were open at the end of March, without a closed date in March 2018)
I use a MATRIX VISUAL not a table visual.
Can you give me a hand? Really grateful.
Best Regards,
JO
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |