Forum Discussion

vipinverma11's avatar
vipinverma11
Frequent Visitor
3 years ago

Need help On dax

Hi, I have one table which has commision date & the calculated column which i am using as a slicer , and the ask here is if i will select any of the slicer so it will exclude the 2 month and r...
Need Help
SadaqatUllah's avatar
SadaqatUllah
New Member
3 years ago
  1. In the table that contains the Commission Date column, add a calculated column with the following DAX formula:ExcludeLast2 =
    IF(
    AND(
    CommissionDate >= EOMONTH(TODAY(),-3)+1,
    CommissionDate < EOMONTH(TODAY(),-1)+1
    ),
    CommissionDate,
    BLANK()
    )
    2. In the report, use the calculated column as the basis for your visualization and the Commission Date column as the slicer.This way, whenever you select a value in the slicer, the calculated column will only show Commission Dates from 2 months ago or earlier.
  • vipinverma11's avatar
    vipinverma11
    Frequent Visitor
    3 years ago

    Thanks for your response,. but that will not work it's returning the same date as mentioned in commision date column