Forum Discussion

Simple_one's avatar
Simple_one
Icon for Helper I rankHelper I
2 years ago
Solved

Need help on Dax

Hello everyone, I have a problem in this visual of Power BI below :       I chosen 3 Months in Slicer : 01-2023, 02-2023, 03-2023 but the visual present all of the months have number of Re...
Need Help
  • BeaBF's avatar
    BeaBF
    2 years ago

    Simple_one You can create a calculated column:

    CHECK_DATE = IF('Offtrack Reenrollment'[OFFTRACK_YM] = 'Offtrack Reenrollment'[YEAR_MONTH], 1, 0)then put this column in filter pane of the matrix visual and select "equals 1":

     

    it will show you only the desidered dates:

     

     

    BBF

Dyuti_M9's avatar
Dyuti_M9
Frequent Visitor
2 years ago

Hi I want to calculate the difference in sales volume per interval of minute as given in the table below however I am getting the wrong result. Can you please help?