Forum Discussion
SUMIF >= column1 AND <= column2
Hello,
I am trying to use following SUMIF formula for DAX measure:
=SUMIFS('(Table 1) Month'!G:G,
'(Table 1) Month'!A:A,Output!K17,
'(Table 1) Month'!B:B,Output!L17,
'(Table 1) Month'!C:C,">="&Output!M17,
'(Table 1) Month'!C:C,"<="&Output!N17)
DAX measure I am currently using is:
10 Replies
Akbarov ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.You can create a column first with multiple conditions, inside sumx measure
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Here you can see details. Results are not correct for some reason. Results are like x2 / x3
When filtering
Client to = A
Policy Year = 2020
Month from 202002 to 202006
Result have to be 151
But it gives result: 273
DAX measure I am currently using is:
Period1 =sumx(filter(allselected('(Table 1) Month'),'(Table 1) Month'[Client] = [Client] &&'(Table 1) Month'[Policy Year] = [Policy Year] &&'(Table 1) Month'[Month] >=SELECTEDVALUE('Start Date'[Month From]) &&'(Table 1) Month'[Month] <=SELECTEDVALUE('End Date'[Month To])),'(Table 1) Month'[Days of Month])Akbarov , refer if this blog can help
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Any help please?
Can anyone help me please?..
