Forum Discussion
BlueRanger
1 year agoFrequent Visitor
DAX Help - complex calculation
Hello, I am encountering a roadblock in the DAX code I am trying to develop and would appreciate any guidance or support! Here is a picture of the work in progress (see below). The first lev...
some_bih
1 year agoCommunity Champion
Hi BlueRanger check example how it is implemented with DAX.DO, Promotion table structure on link. Check also part relatioships with your model (it would be the best to have start and end date of promotion).
On this link it is example how to calculate sales without discount.
Hope this help
BlueRanger
1 year agoFrequent Visitor
Thank you some_bih (love the name)! I am still running into issues. I do however have promotion start and end date in the promotions table. I provided some sample data below to illustrate what I am trying to accomplish. Start and end date is not included in the sample dataset.
- some_bih1 year agoCommunity Champion
Hi BlueRanger Honestly, I do not feel well (some flue, I guess). I will not be able to check your case in following days. I am sorry.
- BlueRanger1 year agoFrequent VisitorNo worries - I appreciate your time. I hope you feel better!