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.
My end goal is to have a table that will count the amount of closed cases/tickets within the last 24 hours and 30 days based off each tech.
columns: tech name | Closed last business day | Closed in last 30 days
John smith | 5 | 60
I was able to create a column with this:
Solved! Go to Solution.
You can add a "Date Closed" column with only dates from "Date/Time Closed", and change this new column to Date type. You can also change "Date/Time Closed" column to Date type if you don't need its timestamp values later.
Then create the following measures with the date column. Put them in a table visual along with Tech name column.
Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0
Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] < TODAY(),'Table'[Date Closed] >= TODAY()-30) + 0
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
This is excellent! Thank you for the help!!
You can add a "Date Closed" column with only dates from "Date/Time Closed", and change this new column to Date type. You can also change "Date/Time Closed" column to Date type if you don't need its timestamp values later.
Then create the following measures with the date column. Put them in a table visual along with Tech name column.
Closed last business day = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] = TODAY()-1) + 0
Closed in last 30 days = CALCULATE(COUNT('Table'[Ticket]),ALL('Table'[Date Closed]),'Table'[Date Closed] < TODAY(),'Table'[Date Closed] >= TODAY()-30) + 0
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
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.