Need help with Dax formulas

[Rinkin_Vaghani]

Guys hello there. I am new to this power BI tool.

I need one more calculated column with repair % (Repair spot*100/Total Spot)

Any help?

[Anonymous]

@Rinkin_Vaghani  hi Mate ,
you can use this .but you have to create a measure .
Repair spot = calculate(sum([repairspot]))
then you have use divide function.

select a new col. then  test = Divide (repair spot)*100,total spot).

  

[amitchandak]

@Rinkin_Vaghani , Try a new column like

New column  = divide([Repair spot], sumx(Table,[TotalSpot]))

Mark it % column, not need multiply by 100

[Rinkin_Vaghani]

@amitchandak Thanks for your reply. But as i said new to power Bi and dont know any formula. Can you elaborate?

[amitchandak]

@Rinkin_Vaghani , It is a new column

New column = divide([Repair spot], sumx(Table,[TotalSpot])) - Repair spot of each row will be divided by total of TotalSpot

https://www.youtube.com/watch?v=cs1ZQU3acWE

[Rinkin_Vaghani]

@amitchandak @Anonymous Thank you guys for your help. I got another solution.

I want another solution now regarding relative date filtering.

I have added slicer to select perticular dates, and i want relative date filtering (last week to be specific) for that selected period. But when i use normal relative filtering, it automaticaly considers last week with my computer date instead of slicer date. Any help here?

Using Power BI August 2018 Version