Forum Discussion

DuaneF's avatar
DuaneF
New Member
1 year ago
Solved

Using Slicer end date in Measure

I'm new to Power BI, and still learning. I have created a measure to determine the last selected date from my date slicer. I want to use this date to determine the date that must be used in a sum que...
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    Hi DuaneF  Try this:

    Total_SOH_Selected_Date = 
CALCULATE(
    SUM(Artikelbestand[Cost_Total]),
    FILTER(
        ALLSELECTED(Artikelbestand),
        Artikelbestand[Trans_Date] = [LastSelectedDate]
    )
)

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution and kudos!!

     

    Best Regards,

    Shahariar Hafiz

shafiz_p's avatar
shafiz_p
Super User
1 year ago

Hi DuaneF  Try this:

Total_SOH_Selected_Date = 
CALCULATE(
    SUM(Artikelbestand[Cost_Total]),
    FILTER(
        ALLSELECTED(Artikelbestand),
        Artikelbestand[Trans_Date] = [LastSelectedDate]
    )
)

 

 

Hope this helps!!

If this solved your problem, please accept it as a solution and kudos!!

 

Best Regards,

Shahariar Hafiz