Forum Discussion
Solved
Help for a novice / newbie please
Hi, I am trying to find the first date, last date, number of orders and refunds for each company. I'm sure this is pretty simple, but any help is much appreciated. I have included a sample of ten rec...
samoht103 , Create measures like these
Total Number of Sales = calculate(count(table[Record_no]), table[Type]="Sales") Total Number of Refund = calculate(count(table[Record_no]), table[Type]="Refund") Earliest Sales date = calculate(Min(table[Date]), table[Type]="Sales") Most Recent Sales date = calculate(max(table[Date]), table[Type]="Sales") Earliest Refund date = calculate(Min(table[Date]), table[Type]="Refund") Most Recent Refund date = calculate(max(table[Date]), table[Type]="Refund") Days Between 1st Sale Last Refund = datediff([Earliest Refund date],[Most Recent Refund date],Day)
nahid3152
Helper II
Helper IIHI,
You can use max & Min function for getting first date & last Date
You can use max & Min function for getting first date & last Date