Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

help for date segment filter

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

Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        v-lid-msft
        Community Support
        6 years ago

        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.