The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I
have sales from 2018 to 2023, I need a measure to calculate 2018 day 1 sales price with total units , if 2018 sales price is not present, I need to calculate it with 2019 or else with 2020 day 1sales price * units. Currently my measure works row by row for sales price * units.please help me to update this .please find the attachment for detailed data
User | Count |
---|---|
24 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
31 | |
12 | |
10 | |
10 | |
9 |