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.
HI
i want to calculate total count
here is my sql code
declare @strdate date ='2021-09-21'
select CONVERT(date, cast( datefromparts(year(@strdate),month(@strdate),1) as datetime) , 120)
result of this query
is 2021-9-01
so it is basically calculating total count from start of the month to till date as
so iam using between operator in dax date column
so how do i calculate the same in power bi
suppose from date is 2021-09-21 and end date is 2021-09-21
so i want to calculate the data from 2021-09-01 to 21-09-2021 how to i do using dax
@parry2k needed your support as always you are .
@amitcha
Solved! Go to Solution.
@fab196 , if date is selected then you can use date tbale and time intelligence
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
or
with today
MTD=
var _min = eomonth(today(),-1)+1
var _max = today()
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )
with date
MTD=
var _max =date(2021,09,01)
var _min = eomonth(_max ),-1)+1
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )
In order to calculate the days between two dates, you can use Datediff.
hope this helps.
@fab196 , if date is selected then you can use date tbale and time intelligence
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
or
with today
MTD=
var _min = eomonth(today(),-1)+1
var _max = today()
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )
with date
MTD=
var _max =date(2021,09,01)
var _min = eomonth(_max ),-1)+1
return
CALCULATE(sum('Table'[Qty]), FILTER(ALL('Table'),'Table'[Date] >= _min && 'Table'[Date] <=_max ) )
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |