Thanks, I actually managed to figure out with some help^^ Got a 3 new questions for ya tho:P
If I have a measure which uses average and is working great and as intended, is it possible to have the SUM shown at the bottom instead of the average in those bold numbers of the table?
Second question is the following: How can I easily create a slicer with following values: January - February March - April May - June Juli - August September - October November - December
So there is 2x months in each "select", I have found a solution but it involves creating 2x dublicates of my date column, one where I transform the date name and replace january with January - February and february with January - February etc etc and then the second column I transform into month ID so I can sort it correctly, but then I also have to replace month id 2 with 1 month id 4 with 3 etc etc and this isnt a pretty solution in my eyes, but it works.
Last question is: I have a table and I want to add a new column with URLs to files on the computer, I have the fileNAME in another column and all the files are in the same directory, so somehow I have to make a custom column as a URL where it takes a value from another field and comebines it with the URL, is this possible and if so how?
1. As the measure use the Average() aggregation, the total row in the same table visual cna't be set to use SUM aggregation. The work around is to create a measure return the SUM value then place it in another visual, and place those two visuals stay together.
I have another BI program, and I have a large report which I am converting to Power Bi, in one column in this table, there is a link to a PDF file in each row, I can press the link and it opens the file, the file is on a share and not a webpage, but I cant figure out how I can do this in pwoer bi.