Thursday, 8 April 2021

Type of DAX Function in Power BI

https://www.tutorialspoint.com/power_bi/dax_basics_in_power_bi.htm

DAX Functions

In Power BI, you can use different function types to analyze data, and create new columns and measures. It includes functions from different categories such as −

  • Aggregate
  • Text
  • Date
  • Logical
  • Counting
  • Information

Power BI provides an easy way to see the list of all functions. When you start typing your function in the formula bar, you can see the list of all functions starting with that alphabet.

Aggregate Functions

DAX has a number of aggregate functions.

  • MIN
  • MAX
  • Average
  • SUM
  • SUMX

Counting Functions

Other counting functions in DAX include −

  • DISTINCTCOUNT
  • COUNT
  • COUNTA
  • COUNTROWS
  • COUNTBLANK

Logical Functions

Following are the collection of Logical functions −

  • AND
  • OR
  • NOT
  • IF
  • IFERROR

TEXT Functions

  • REPLACE
  • SEARCH
  • UPPER
  • FIXED
  • CONCATENATE

DATE Functions

  • DATE
  • HOUR
  • WEEKDAY
  • NOW
  • EOMONTH

INFORMATION Functions

  • ISBLANK
  • ISNUMBER
  • ISTEXT
  • ISNONTEXT
  • ISERROR

DAX Calculation Types

In Power BI, you can create two primary calculations using DAX −

  • Calculated columns
  • Calculated measures

Tuesday, 30 March 2021

Drinking hot water

 What is the use of drinking hot water?

https://www.quora.com/q/growhealth/What-is-the-use-of-drinking-hot-water?ch=10&share=f20bbba6&srid=TZoV

6 Health Benefits of Hot Water

Apart from weight loss, hot water offers several health benefits as follows.

  • Maintains Blood Pressure: Drinking hot water helps in better blood circulation & flushes out the toxins from the body. Healthy blood flow keeps your blood pressure and the cardiovascular system in good condition.
  • Soft & Glowing Skin: Drinking warm water improves the circulatory system & rejuvenates the skin cells by supplying nutrients throughout the body. It keeps your skin hydrated, soft, and glowing.
  • Happy Tummy: Consuming hot water improves digestion as it breaks down the food faster and reduces the risk of constipation. Drinking a small glass of warm water before a meal boosts your metabolism.
  • Morning Freshness: Drink a glass of hot water right after you leave the bed in the morning. It will help your body recover from the overnight loss of fluids. Improved blood circulation in the morning would keep you energized and happy for the whole day.
  • Initiates Body Detoxification: Hot water increases body temperature causing you to sweat; thus, your body flushes out the toxins from the skin and cleans up the pores.
  • Less Painful Periods (Dysmenorrhea): Sipping up hot water during periods increases the blood flow, relaxing the tensed muscles resulting in reduced cramps. If you don’t like the plain water,add some herbs, lemon, and honey to make it a drink & let the magic happen!