Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
@Anonymous , Last year last three months rolling
Rolling 3 lasy year= CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-13),-3,MONTH))
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |