Forum Discussion
Help Converting an Excel countifs function into Power BI
Hi all, I am new to the forum and new to Power-Bi and I really need a little help. I have been given an excel sheet and asked to convert it to Power-Bi. I am really stuck with 1 formula in pa...
Hi,
That seems to work for an overall count on all records but when i use my closed date filter / slider it does not filter this new column qty. it still reads the figure for all data.
Therefore one item will have a figure like 2192 next to it when i am expecting between 1 and 5 for a given day?
Hi,
If you wish to use a slicer, then no calculated column formula approach would work because a slicer selection does not cause a calculated column to recalculate. Calculated columns are recalculated only at the time of opening the file or when clicking on Refresh.
It will help a lot if you explain the data, the business problem and show your expected result.