Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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
    7 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.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
7 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