The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hii..
I have a requirement to calculate last year sales i.e if today date is 19/oct/2019 i need the last year sales from 01/Jan/2018 to 19/Oct/2018
I have used
Solved! Go to Solution.
It would certainly help if you show a sample of your tables. Assuming you are looking for a measure, try this in a card visual:
Measure = VAR First_ = DATE ( YEAR ( TODAY () ) - 1; 1; 1 ) VAR Last_ = EDATE ( TODAY (); -12 ) RETURN CALCULATE ( SUM ( Table1[Sales] ); Table1[Date] >= First_; Table1[Date] <= Last_ )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
It would certainly help if you show a sample of your tables. Assuming you are looking for a measure, try this in a card visual:
Measure = VAR First_ = DATE ( YEAR ( TODAY () ) - 1; 1; 1 ) VAR Last_ = EDATE ( TODAY (); -12 ) RETURN CALCULATE ( SUM ( Table1[Sales] ); Table1[Date] >= First_; Table1[Date] <= Last_ )
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |