Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
6 years ago

Create Slicer for Measure ,

Hi ,  good day.  I have built a report which to track how many Outlets are Active or InActive , All are Tracking based on duration of 3 , 6 & 12 Months. I have created the formula for 3 months , 6...
Need Help
JQuon's avatar
JQuon
Helper I
6 years ago

Actually, after reviewing your question and the design behind the logic, I understand where the complication is.  Let me digest this a little more and see if I can come up with a solution.

Chanleakna123's avatar
Chanleakna123
Post Prodigy
6 years ago

JQuon , hi  do you have any update in this regards ? 
looking forward your response 🙂 . 

 

Thanks with Regards, 
Chanleakna Hang 

  • JQuon's avatar
    JQuon
    Helper I
    6 years ago

    Chanleakna123 , are you able to share the PBIX file?  I think the only way to do this is through calculated columns.  It may not be ideal, but you may not to do calculated columns on an aggregate table to achieve your goal.

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy
      6 years ago

      hi v-xicai  it doesn't shown the preference result . 

       

      HI JQuon  i have shared through the message of the BI File. Can you please review it ? 

      thx 

      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        6 years ago

        hi JQuon , i haven't received any feedbacks on this , can you please help