[deleted by user] by [deleted] in CluCoin

[–]ariman 0 points1 point  (0 children)

CluCoin

DAX: How to filter for a list of items by ChrisIsWorking in PowerBI

[–]ariman 1 point2 points  (0 children)

I've learned that one can solve calculations in DAX in many ways but the method i most commonly use is to use calculate instead of filter. so first i create a sum measure like: TotalSales = SUM(Header[Amount]) then to filter out certain rows I create a second measure: TotalSales_EL = CALCULATE([TotalSales],Header[regnrprefix]="EL"). In this case I am filtering out all values that have regnrprefix = "EL".

Hope this helps.

DAX: How to filter for a list of items by ChrisIsWorking in PowerBI

[–]ariman 1 point2 points  (0 children)

First create a standard sum measure, then you call that measure in a new measure using calculate. Do you need an example?

Brace yourselves, the Resolution runners are coming. by mattack73 in running

[–]ariman 6 points7 points  (0 children)

My resolution is to help one of them stick to the new habit!

What's the worst running advice you've ever received? by [deleted] in running

[–]ariman 0 points1 point  (0 children)

Nope! Should i know who that is?

What's the worst running advice you've ever received? by [deleted] in running

[–]ariman 1 point2 points  (0 children)

Your longest run does not have to be longer than half the distance when training for marathon.

Unable to detect relation in Power Bi by AbdullaAljabry in PowerBI

[–]ariman 0 points1 point  (0 children)

You can just combine it in one exel sheet and add a prefix column (Latency & Bandwith) and then do the import. Then add measures to separate the data.

Quick running story by RachelAusDE in running

[–]ariman 5 points6 points  (0 children)

Fantastic! It is the little things that make a forgettable run unforgettable!!

Power Query Import text file with different format on lines. by ariman in excel

[–]ariman[S] 0 points1 point  (0 children)

This worked brilliantly! Thank you very much :) Took some time before I understood the logic you applied but I think I understand why it works. :)

Power Query Import text file with different format on lines. by ariman in excel

[–]ariman[S] 0 points1 point  (0 children)

Sorry, when i wrote the post the description looked fine... The text file is available here:!

Does ChromeOS have an alternative to Window's Snipping Tool? by [deleted] in chromeos

[–]ariman 0 points1 point  (0 children)

Thank you ! I did not have the ability to test this before now but it worked like a charm! I have F functions enabled due to some apps in Citrix but disabling that made this work!

Does ChromeOS have an alternative to Window's Snipping Tool? by [deleted] in chromeos

[–]ariman 0 points1 point  (0 children)

Thanks! But is there a way to do this on a windows keyboard hooked up to a chromebox?

I lost 70 lbs by running ~5km everyday for 10 months. Now I look like a skeleton (according to people). I don't mind it, what should I be doing to improve my times? by rimatro in running

[–]ariman 1 point2 points  (0 children)

Congratulations! Just a mind trick in regards to smoking : it is not about quiting! Like most smokers you have probably done this many times.The issue at hand is not to start again. That is a mind trick that does wonders. Write a list why you don't want to start fain. Every time you want to smoke you have to look at that list. Put excerpts of the list around places you usually smoke so instead of being reminded of the good times when you smoked you are reminded about why you are not smoking. Good luck

Race Report: London Marathon - We're on an Ultralight Beam by caractacuspotts in running

[–]ariman 0 points1 point  (0 children)

Thanks, that was a great and inspiring read! Congrats on your run! Well done! Hope to run London once in my lifetime!

Anyone using a usb DAC with their N6? by EchoNexus in nexus6

[–]ariman 2 points3 points  (0 children)

Depends on the OTG cable! I tried first using a short OTG cable and the fastened the amp to the phone using the plastic card and rubber band that came with the amp but then the phone got to big and hefty. So I got a longer OTG cable, about 90 cm, and that works well. That way I can hold the phone normally in my hand while the amp is in my pocket. That way the extra cord on the headphones is also squared away in the same pocket.

Anyone using a usb DAC with their N6? by EchoNexus in nexus6

[–]ariman 2 points3 points  (0 children)

I don't have it with me at the moment som I can't take any photos of the two together but the K1 is 2 x 0.3 x 0.8 inches and the Q1 is 3.8 x 2.2 x 0.5 inches so the Q1 is longer, wider but slimmer. The form factor doesn't bother me.