Forum Discussion

fazou's avatar
fazou
Frequent Visitor
1 year ago
Solved

USERRELATIONSHIP

Hello Guys 🙂  i have a problem using USERELATIONSHIP (maybe it's not the problem) i'll explain. Below my model Below the results  i'm selecting WTD from TBD_PERIOD which is 19/05...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi fazou ,
    Thank you for reaching out to us on Microsoft Fabric Community Forum!

    Upon my understanding,I tried to recreate it on my end.So I followed below steps which might help you to resolve the issue.

    1.Create a calulated column using below:

    SegmentAtSaleDate =
    CALCULATE (
        MAX ( 'TBF_SEGMENTATION_HISTO'[SEGMENT] ),
        FILTER (
            'TBF_SEGMENTATION_HISTO',
            'TBF_SEGMENTATION_HISTO'[CUSTOMER_ID] = 'TBF_SALES'[CUSTOMER_ID] &&
            'TBF_SEGMENTATION_HISTO'[START_DATE] <= 'TBF_SALES'[ORIGINAL_ORDER_DATE]
        )
    )

    2.Then create a measure using below:
    TTotal Sales CY by Segment =
    VAR SelectedStart = MIN('TBD_PERIOD'[START_DATE])
    VAR SelectedEnd = MAX('TBD_PERIOD'[END_DATE])
    RETURN
    CALCULATE (
        SUM('TBF_SALES'[NET_SALES]),
        FILTER (
            'TBF_SALES',
            'TBF_SALES'[ORIGINAL_ORDER_DATE] >= SelectedStart &&
            'TBF_SALES'[ORIGINAL_ORDER_DATE] <= SelectedEnd
        )
    )

    3.Please refer the screenshot and file for your reference:


    Hope this answer meets your requirements.If so,give us kudos and consider accepting it as solution.

    Regards,
    Pallavi.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi fazou ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.