Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

DAX Formula and Measure Question

Hello everyone! My data is depicted below (1st picture). It is pretty simple, I created the Total Subtasks Completed and the % of PP Progress columns. The total subtasks completed is the sum of the a...
Need Help
question
Show & Tell
  • FreemanZ's avatar
    FreemanZ
    3 years ago
    Supposing your table named Data, try to add a column with the code below:
    PctRange =
    SWITCH(
        TRUE(),
        Data[% of PP Progress] <=0.25, "0-25%",
        Data[% of PP Progress] <=0.5, "26%-50%",
        Data[% of PP Progress] <=0.75, "51%-75%",
        "76%-100%"
    )
Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
3 years ago

You can group your data without DAX! Click the column you're wanting to group and under column tools > data groups > New data groups


Then you can toss those %s in buckets

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I never knew this! When I tried to do it, I got this popup which I've never seen before.