Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have the following YTD calculations:
Solved! Go to Solution.
Can you not add the two measures you have?
Have you tried with || , since you want both:
YTD_inbound_lines_in_time_OR_early = TOTALYTD ( COUNT ( Purchasing_data[OTD 0d] ), Date_table[Date], Purchasing_data[OTD 0d] IN { "On Time", "Early" } )
But this measure should provide the same result as adding the two you already have. Each item can be either "On Time" or "Early", right?
Hi @Hyperchef1969,
Could you please mark the proper answers as solutions?
Best Regards,
Can you not add the two measures you have?
Have you tried with || , since you want both:
YTD_inbound_lines_in_time_OR_early = TOTALYTD ( COUNT ( Purchasing_data[OTD 0d] ), Date_table[Date], Purchasing_data[OTD 0d] IN { "On Time", "Early" } )
But this measure should provide the same result as adding the two you already have. Each item can be either "On Time" or "Early", right?
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |