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 community,
searching for some help for the following:
I have a table with entries..each rows a job with different dates.somehwat like this..
In powerBi I added all those additional columns for date calculation to my initial excel source.
1. question: Can I avoid this and do this with a measure / DAX?
I added 3 addtional grouping colums for this 3 calculated datediff in which I group this depending on how many days (e.g. how many are less than 1day, how many are 2-3 days, ...) I currently use grouping function for this with list, but this gives me the issue that I can only build the groups on existing datediff.
This leads to 2nd question: Can I do this easier / Better? Also probably without adding additional columns?
And this leads to the 3rd and last question:
I added another 3 columns related to 3 tables (which holds the same data in each table) to order my data the same way all the time. Can I avoid this as well?
Thanks for your help, I hope my issue is explained clear enough
Solved! Go to Solution.
@hummes ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.
@hummes ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.
OK, I try to elaborate a bit.
1. Topic: using DAX (or whatever tech) instead of this 3 (DATEDIFF) columns? Would this be possible?
2. Topic Grouping: Can I do this with DAX (or whatever tech) instead of adding columns?
and how can I remove the solution...i missclicked 🤔
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 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |