Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, I want to find the value of sales to new clients this year. My table is Client Name, Invoice Date and Amount and the dates are spread over 2 fiscal years. I simply need a measure (not a standalone table with filters) that I can add to a table showing the value of clients billed in Year 2 but not in year 1, but most importantly provides a total that I can use. I have produced a number of measures which appear to give me the list, but none are able to produce a total. Any help much appreciated...
Solved! Go to Solution.
Hi @Tim_Walker,
Sum sales = IF ( CALCULATE ( COUNTROWS ( data ), FILTER ( ALLEXCEPT ( data, data[Client Name] ), data[Invoice Date].[Year] < YEAR ( TODAY () ) ) ) < 1, CALCULATE ( SUM ( data[Amount] ), ALLEXCEPT ( data, data[Client Name] ) ), BLANK () )
Best regards,
Yuliana Gu
Hi @Tim_Walker,
Sum sales = IF ( CALCULATE ( COUNTROWS ( data ), FILTER ( ALLEXCEPT ( data, data[Client Name] ), data[Invoice Date].[Year] < YEAR ( TODAY () ) ) ) < 1, CALCULATE ( SUM ( data[Amount] ), ALLEXCEPT ( data, data[Client Name] ) ), BLANK () )
Best regards,
Yuliana Gu
User | Count |
---|---|
83 | |
76 | |
71 | |
68 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |