Forum Discussion

Yousra-ali's avatar
Yousra-ali
New Member
11 months ago
Solved

Periods Comparison

Hello Dears,   i have created table date and dublictae it and call it comparison, i have linked it to the main sales table i have, so now i have 2 slicer one is current period and the other one is ...
Need Help
Tutorial Requests
  • danextian's avatar
    danextian
    11 months ago

    Hi Yousra-ali 

     

    If the goal is to compare to periods controlled by different slicers, use a second dates/calendar table that has an active relationship to your fact table. Invoke the inactive relationship in a table using USERELATIONSHIP. You also need to remove the filter coming from the dates table with an active relationship to fact

    Total Revenue Comparison = 
CALCULATE (
    [Total Revenue],
    USERELATIONSHIP ( ComparisonDates[Date], Data[Date] ), 
    REMOVEFILTERS ( Dates )
)

     

     

    Please see the attached pbix.

danextian's avatar
danextian
Super User
11 months ago

Hi Yousra-ali 

 

If the goal is to compare to periods controlled by different slicers, use a second dates/calendar table that has an active relationship to your fact table. Invoke the inactive relationship in a table using USERELATIONSHIP. You also need to remove the filter coming from the dates table with an active relationship to fact

Total Revenue Comparison = 
CALCULATE (
    [Total Revenue],
    USERELATIONSHIP ( ComparisonDates[Date], Data[Date] ), 
    REMOVEFILTERS ( Dates )
)

 

 

Please see the attached pbix.