I’m new to Power Bi and I’m facing a serious problem. I have Sales table in which there is column named Moony. The table is like this:

Hi there,

I’m trying to display previous year [Total Sales] on a card visual. Below is the DAX function that I have written for this.

I have a DAX SWITCH statement where I would like the result (scalar expression to be evaluated if the results of expression match the corresponding value) for the new column to be defined as the concatenation of the values in 2 columns in the table.

I want to create an ‘exclude’ slicer in power bi to filter and display records that do not have the slicer selected values in my visuals.

I have an excel file which contains the following columns: position (machine), company, workshop, date, article, quantity produced, quantity rejected, machine opening time. I want to calculate % productivity dax formula how to do it

I’m having some trouble calculating the total run time for these. I can get somewhere near using the DIFFDATE calculation but I can only get minutes or hours and not both – and sometimes because of the time format I get a minus number too? Would love some help to get the run time in hh:mm:ss -thanks

I’m working on improving the performance of a calculation of the penetration rate. Taking our sales invoice fact table that goes down to sales invoice lines, the logic is: