Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello friends,
Im new to powerbi environment . Im learning myself with various resources .
I got an scenario to calculate the total sales only for january and march with using dax formulas .
it is like calculate the total sales for any two months from the data.
please help me
Solved! Go to Solution.
@ashikts , one way to select from the month slicer.
or static measure like
calculate(sum(Table[values]), filter(Table, eomonth(table[Date],0) =date(2020,01,31) || eomonth(table[Date],0) =date(2020,03,31)))
worked
@ashikts , one way to select from the month slicer.
or static measure like
calculate(sum(Table[values]), filter(Table, eomonth(table[Date],0) =date(2020,01,31) || eomonth(table[Date],0) =date(2020,03,31)))
it didnt work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |