Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Capture weekly sales

Guys,

I need help capturing one week sales or weekly sales. can someone help rewrite the DAX. when i validation it with weeknum it displayed. but when i try another attribute it show blank.  

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    Brother SELECTEDVALUE returns blank because there are multiple weeks per each business.
    Select a week from the slicer, results should appear 

  • Anonymous's avatar
    Anonymous
    4 years ago

    tamerj1  Thanks for your reponse. but, i need to break it down by business. there's not slicer for weekNum. 
    how can i write the DAX to display Business. 

7 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Brother SELECTEDVALUE returns blank because there are multiple weeks per each business.
    Select a week from the slicer, results should appear 

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      tamerj1  Thanks for your reponse. but, i need to break it down by business. there's not slicer for weekNum. 
      how can i write the DAX to display Business. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        tamerj1  You are correct, i need to add a slicer for fiscal Number. Thanks