powerbi desktop

I need to calculate actaul variance  and net variance by slected 2 dates from slicer for eg(base date = 1/1/2019 and coampare date = 6/1/2019 actual variance =1 and net =2 but for base date = 6/1/2019 and copare date 1/1/2019 actaul variance =0 and net variance =2)

Anonymous Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Anonymous , refer if this blog can help

https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

You can use single date if needed

Hi, Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

Base Date(a calculated table):

Base Date = DISTINCT('Table'[Date])

Compare Date(a calculated table):

Compare Date = DISTINCT('Table'[Date])

You may create three measures as below.

Count of Dimensions = COUNTROWS('Table')

Net variance = 
IF(
    HASONEVALUE('Base Date'[Date])&&HASONEVALUE('Compare Date'[Date]),
    COUNTROWS(
        FILTER(
            'Table',
            [Date]=SELECTEDVALUE('Compare Date'[Date])
        )
    )-
    COUNTROWS(
        FILTER(
            'Table',
            [Date]=SELECTEDVALUE('Base Date'[Date])
        )
    )
)

Actual varaince = 
var _comparetab =
CALCULATETABLE(
    DISTINCT('Table'[Dimension]),
    FILTER(
        ALL('Table'),
        'Table'[Date]=SELECTEDVALUE('Compare Date'[Date])
    )
)
var _basetab = 
CALCULATETABLE(
    DISTINCT('Table'[Dimension]),
    FILTER(
        ALL('Table'),
        'Table'[Date]=SELECTEDVALUE('Base Date'[Date])
    )
)
var _result = 
COUNTROWS(
    FILTER(
        _comparetab,
        NOT([Dimension] in _basetab)
    )
)
return
IF(
    HASONEVALUE('Base Date'[Date])&&HASONEVALUE('Compare Date'[Date]),
    IF(
        ISBLANK(_result),
        0,
        _result
    )
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.