help for date segment filter

[Anonymous]

HI im french and i try to do two visual like those photos for Suez france, and i start my mission so i need help, 

Thank you ,
Raphael

[v-lid-msft]

Hi @Anonymous ,

Before my answer, I want to remind you that this is a public community forum, you should not put your personal information in your post such as company information. You'd better edit this, just leave problem describtion and your requirement is enough.

For the first picture, you can create a calculate column in your data table like following

DateSegment =
IF (
    [End Date] - [Start Date] > 180,
    ">6 month",
    IF ( [End Date] - [Start Date] > 90, ">3 month <6 month", "<3 month" )
)

For the second picture, so I assume sake range is something like the date range.

Sakrange =
VAR s = [Sak End] - [Sak Start]
RETURN
    IF (
        s > 1,
        ">1",
        IF (
            s > 0.5,
            "0.5 - 1",
            IF ( s > 0.25, "0.25 - 0.5", IF ( s > 0.1, "0.1 - 0.25", "<0.1" ) )
        )
    )

If it doesn't meet your requirement, kindly share your  excepted result to me based on my sample data.

BTW, pbix as attached.

Best regards,

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more 

[Anonymous]

Thank for your time and your answer ! I do the first visual it work good, For the second it's not a date range but a turnover sale range sorry for my writing .

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

You can just change the variable "s" in the second formula to the calculate the turnover sale range if the value in this row.

Sakrange =
VAR s = [cost] / [total]
RETURN
    IF (
        s > 1,
        ">1",
        IF (
            s > 0.5,
            "0.5 - 1",
            IF ( s > 0.25, "0.25 - 0.5", IF ( s > 0.1, "0.1 - 0.25", "<0.1" ) )
        )
    )

The Thought of this formula is just to calculate the value for each row and judge this value to create a new column by group.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.