Forum Discussion

kdendukuri's avatar
kdendukuri
New Member
4 years ago

Help with slicer

I have Customer key, Officekey and Datetrx and DatePurge, Amount. I need my report with the below conditions   1. Datepurge is null or Datepurge >= VariableDate (a Date that user selects) 2. Datet...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

kdendukuri , With a small changes

 

VAR FilteredTable =
CALCULATETABLE (
MGA_AROPEN,Filter(MGA_AROPEN,
MGA_AROPEN[CONO]=10 && MGA_AROPEN[COVTYPE]="ComTitle" && MGA_AROPEN[DATETRX] <= seldatetrx &&
OR(ISBLANK(MGA_AROPEN[DATEPURGE]), MGA_AROPEN[DATEPURGE]>= seldatepurge)))

VAR Result = SUMX ( FilteredTable, MGA_AROPEN[AMOUNTNET] )

 

 

Also, refer approach in

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

  • kdendukuri's avatar
    kdendukuri
    New Member
    4 years ago

    I dont have issue with the my dax formula. It is working as expected when i dont have slicers Datepurge and Datetrx in my report. WHen i have those slicers and i chose same value for both which is my varibaledate , i have my other dimesnison values getting as these slicers getting applied and i cant enforce datepurge to have "is null" or >= Variable Date only >=varibale date can be done using slicer