Forum Discussion
Data format
Hello,
I have a problem in creating groups from a column: I need to have several new groups ("2 giorni", "da 2 a 5 giorni", "oltre 5 giorni") in numeric format but at the end I have these in text format (with the addition of the "Altro" field) and so I have a big problem in the creation of graphs.
Please find the photo attached.
Thank you very much for help me,
Nicola
DigitalAutomat Seems like:
Column = SWITCH(TRUE(), [delivery time (days)] < 2, "delivery within 2 days", [delivery time (days)] >= 2 && [delivery time (days)] <= 5, "delivery between 2 and 5 days", "delivery over 5 days" )
3 Replies
DigitalAutomat Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Dear Greg_Deckler ,
Thank you for your kind answer and clarifications; here is my sample text:
date
delivery time (days) 29th january 2 28th january 1 27th january 5 26th january 4 25th january 3 20th january 2 14th january 1 First of all I need to create 3 groups, based on the following delivery time:
first group: delivery within 2 days
second group: delivery between 2 and 5 days
third group: delivery over 5 days
this is a sample table based on my previous data:
delivery in 1 day: delivery between 2 and 5 days: delivery over 5 days: 2 5 0
Lastly, I need to create a pie chart related to these data, like this one:Please feel free to ask if you need any additional information.
Thanking for your help I look forward to hearing from you.
Kind regards,
Nicola
DigitalAutomat Seems like:
Column = SWITCH(TRUE(), [delivery time (days)] < 2, "delivery within 2 days", [delivery time (days)] >= 2 && [delivery time (days)] <= 5, "delivery between 2 and 5 days", "delivery over 5 days" )
