Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have report in direct query.I wanted to get the previous day sales.How can I achieve this in direct query.
Thank yOU
Hi @ann33
You can use the function PREVIOUSDAY which is supported with measures in Direct Query mode
https://learn.microsoft.com/en-us/dax/previousday-function-dax
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |