Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
1 year ago
Solved

SWITCH for 2 different date columns

I have a report that displays daily sales. In the sales table, I have two columns with date information. I would like to have a switch in the report that distinguishes between both perspectives. ...
Need Help
  • speedramps's avatar
    speedramps
    1 year ago

    Click here to downlaod a solution from one drive.

    Look at the documentation on all pages, on the relationships and inside the dax measures

    Please click thumbs up and accept solution button. Thank you

     

    Click here 

     

     

  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi joshua1990,

     

    Thank you for providing information on your issue. I’ve reviewed your scenario and successfully replicated it using sample data on my end.

    I’m sharing the working .pbix file below so you can explore the setup and DAX logic more clearly. Please feel free to open it and review how the relationships and measures are configured:

     

    I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.

    If you found this post useful, kindly give it a ‘Kudos’ and mark it as a solution so others facing similar challenges can find it more easily.

    Thanks for being part of the Microsoft Community!

speedramps's avatar
speedramps
Super User
1 year ago

Hi joshua1990 

 

I went to a lot of effort to provide an explanation and example.
Did you try my method?

Please click thumbs up and the [accept as solution] buttons.

It is polite and sensible to thank helpers this way.  😀