Hello community, Please help, I need to create a table with custom periods: Last 15 Months Previous 15 Months Years I create all I needed in the calendar table:  ...
Hello all. I have two Lookup tables. One of it has data about learning courses (number of course, Course Start data, the quantitiy of the participants etc). The second one is a person table ...
Hi Friends, I am trying to get second largest value of sum of selected rows. Currently i am able to get only 2nd largest value of the selection with below dax, however not able to achive the...
Hi, I am in the process of converting a load of Tableau dashboards into Power BI but cannot figure out how to translate this particular measure and was hoping someone could point me in the right dir...
hi all I want to display measures in row not column i have several measures like sum of current year / sum of previous month / sum of previous year and i want to display measures by branch ...
I have a data set like the below and am building a report in Power Pivot. Thanks to previous help HERE, I was able to make a pivot table that excluded any citites from the pivot table that ...
How to calculate average of sum for each month from all yeras Hello I'm wondering how solve problem with calculate average of sum in each month. I got 2 tables, first is Calendar ...
Hi, Thanks for looking at my post. I have below formula and can anyone help me to modify this to add 2 days on top of this please? Date = SWITCH(TRUE(), &n...
Hola. Tengo una tabla de datos, de la actividad de un taller. Entre sus datos tengo el numero de orden de reparacion, y las matriculas de los vehículos que entran en el taller. Un vehículo, p...
Hi, I'm working on a report where I have to show quarterly data based upon one or multiple years selected from the filter. I want to store the smallest year value for which i have created a measure s...