Forum Discussion

Fantmas's avatar
Fantmas
Icon for Helper III rankHelper III
4 years ago
Solved

Create Waterfall Chart with breakdown based on date Selected value

Hi all,   I am new in the PowerBi journey, I am trying to create a waterfall that display movement from based on a date value in a slicer,   in my measure I got the following error message and I ...
  • Fantmas's avatar
    Fantmas
    4 years ago

    Hi,

    Thank you for your feedback, it sems working now,

    I amr requesting a last support from powerBi community , I Try get the sum of previous month value based on Slicer selection my code return me blank and I do not understand why :



     

    M-1 = Calculate( [FTE MTD], REMOVEFILTERS( DimDate[Date] ), 'Fact FTE'[Period Available] = EOMONTH( SELECTEDVALUE(DimDate[Date]),-1))

     

     

     

Fantmas's avatar
Fantmas
Icon for Helper III rankHelper III
4 years ago

Hi,

Thank you for your feedback, it sems working now,

I amr requesting a last support from powerBi community , I Try get the sum of previous month value based on Slicer selection my code return me blank and I do not understand why :



 

M-1 = Calculate( [FTE MTD], REMOVEFILTERS( DimDate[Date] ), 'Fact FTE'[Period Available] = EOMONTH( SELECTEDVALUE(DimDate[Date]),-1))