Forum Discussion
Akbarov
Helper I
Helper ISUMIF >= 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,...
AkbarovHelper I
Helper IHere 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])
amitchandak
Super User
Super UserAkbarov , 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.
- Akbarov
Actuly my data is not really data so tutorial which you provided wont help me.
Can you please take a look?
https://drive.google.com/file/d/1dokknVDmqXdJSmb2yFrOwoRdIjVDhLfl/view?usp=sharing
