meausre

2 Topics

The total is coming incorrect.
member, I am using the below measure to divide the sum i.e. _FTE by _countRows. The VAR_FTE gives me 9.85. VAR_countRows gives me 10. I want to see the total of VAR_divFTE as 2.85 i.e. 0.85+1+1. However, it is dividing (=9.85/10) and giving me total as 0.985. Can someone please suggest what changes needs to be done in VAR_divFTE to get the total of 2.85 NOTE : I am using Power BI dataset as a source here and cannot resolve this issue by creating calculated column, writing a DAX meausre is the only option.
Solved
Anonymous
3 years ago Place DAX Commands and Tips
1.4KViews
0likes
6Comments
SUM values in table where months are not equal between two date columns
Hello, I have a sales table here with three columns: Transaction Date Sale Date Quantity 12/31/2020 01/03/2021 10 12/29/2020 12/30/2020 5 01/04/2021 01/05/2021 5 01/20/2021 02/01/2021 10 I also have a date table with the following relationships, one is active where the other is inactive: Date Table Sales Table [Date]1:*[Transaction Date] Date Table Sales Table [Date]1:*[Sale Date] (INACTIVE) How do I write a measure that will only sum the quantities where the Transaction Date (MONTH) is not equal to the Sale Date (MONTH)? I want the result to look like this: Transaction Month Sale Date Quantity December 01/03/2021 10 January 02/01/2021 10 Thank you so much in advance for your help.
Solved
l0ganBI
5 years ago Place DAX Commands and Tips
849Views
0likes
1Comment