hi, am a newbie here and looking for support on a calculation...
Scenarios: i need to sum the dataset with the following:
There are many transaction types. all transaction types except for "IWO_WH_PRG" should be summed based on the Effective date drop down filter on the report.
For the "IWO_WH_PRG" transaction type, the sum should ignore the effective date
Result should be like below:
Go to Solution.
It’s my pleasure to answer for you.
According to your description, If you don’t want the effective date to filter a certain type, it’s not very recommended that displaying in one visual, there will be ambiguity.
You can try like this:
IWO_WH_PRG =SUMX(FILTER(ALL(Table1),[Transaction Type]="IWO_WH_PRG"),[Man Hours])
If it doesn’t solve your problem, please feel free to ask me.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021