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 ,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!