Forum Discussion

BlueSkyX's avatar
BlueSkyX
Regular Visitor
2 years ago
Solved

Sort amounts into groups/columns

I´m (more or less) an absolut PBI newbie and need some help.   I have a list with amounts and deadlines (in the past and upcoming) and calculated with DATEDIFF the corresponding due days (a few tho...
Need Help
  • BlueSkyX's avatar
    BlueSkyX
    2 years ago

    Thanks for your support!

     

    Meanwhile I adjusted the data table a little bit and integrated xthe calculation of the due days with a measures. This step enables the possibility to insert the groups by "conditional column". Maybe not the professional way but for me the most logical one. 😉

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi BlueSkyX 

You can consider to create a calculated column with siwtch() funcion.

e.g 

Type =
SWITCH (
    TRUE (),
    [Due Days] >= 1
        && [Due Days] <= 5, "Due 1-5",
    [Due Days] >= 6
        && [Due Days] <= 10, "Due 6-10",
    [Due Days] >= 11, "Due >11"
)

Then you can put them into a matrix visual

e.g 

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.