Forum Discussion

abhishekc1's avatar
abhishekc1
Frequent Visitor
7 years ago
Solved

Dynamically change state based on date slicer - help required

Hi All,   I have a table that looks like this:   Location Start Date loc 1 1-Jan-19 loc 2 13-Feb-19 loc 3 17-Feb-19 loc 4 1-Aug-18 loc 5 1-Jun-19 loc 6 13-May-19 lo...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

I can only understand the answer of point a.  I cannot understand the expected answer of b, c and d.  GIven an explanation.

abhishekc1's avatar
abhishekc1
Frequent Visitor
7 years ago

It's the way we classify locations internally. basically, each location is the location of a retail store. Any store that is less than 2 months old is classified as New internally. Could you help me figure it out in this context? I'll try to work on it by modifying the formula from your solution sheet and see if i can get this done. Anyway, thank you so much once again

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi

    Share some data and in your expected format (with a slicer for time period applied), show the expected output with an explanation.

    • abhishekc1's avatar
      abhishekc1
      Frequent Visitor
      7 years ago

      Hi Ashish,

       

      I just used the logic in your file and figured out a solution for my problem. I just created a month index and modified the logic from your solution. I'm very new to all of this so Thank you so much for all the help. Really appreciate it! Also, my apologies for not sharing enough details earlier. 

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        You are most welcome.  Glad you could find a solution by yourself.