Forum Discussion
How to create a measure
Hello, Sorry this may be simple but I am new to Power BI. I need to count the number of sales of the target items in the sales report like below. (colored cells) The target Items is basically A, b...
Hi Jihwan_Kim,
Thank you for your reply!
Is it possible to obtain the results without having to create a "target" table?
In another similar report that I am currently working on, there are 7 types of items (A, B, C, D, E, F, G), and only "A" needs to be calculated after FY23. It would be even more helpful if I didn't have to add "A" to the target table every year.
FY20 = "A"
FY21 = "A", "B"
FY22 = "A", "C"
FY23,24,25..... = "A"