Power bi project - Dax measures

Status: Closed
Prize: $50
Entries Received: 15

Contest Brief

I have quite experience with power bi at the level of visualization using available measures but iam not able to creat sales measures for my work

I need some one to help with creation of sales measures that enable me to
Compare this year sales with last year sales monthly and also to date ( april is the first month of the year for our work )

Creat Moving annual totals for the data

I have my sales data reay in 4 columns

Column 1 : date
Column 2 : sales quantity for this specific date ( many rows as day may have many sales for different customers)

Column 3 : Customer name

Column 4 : Customer location

The work will need the freelance to contact me on zoom or any tool as the data can’t be sent and i have to work on my machine so he will need to guide me how to write or manage the needed functions or measures

You need to have the skill and the english basics needed for communications

I expect the task to be done in couple of hours or less and if need more i will pay extra 25 USD / hour work

Recommended Skills

Post a Contest Like This

Public Clarification Board

PaulDragoA
- 1 year ago
Hi, online now and willing to talk you through the requirement if you are still interested :)
- 1 year ago
sruthishradda
- 1 year ago
we can discuss about project
- 1 year ago
sruthishradda
- 1 year ago
u message me in chat
- 1 year ago
sruthishradda
- 1 year ago
yes
- 1 year ago
sruthishradda
- 1 year ago
yes
- 1 year ago
1. Contest Holder
  - 1 year ago
  are you ready now
  - 1 year ago
sruthishradda
- 1 year ago
plz check entry 6
- 1 year ago
1. Contest Holder
  - 1 year ago
  do you know Dax
  - 1 year ago
ahmedfouda114
- 1 year ago
connect with me please
- 1 year ago
1. Contest Holder
  - 1 year ago
  how ?
  - 1 year ago
PaulDragoA
- 1 year ago
Hi, there. Thanks for the opportunity to compete on this contest. I'm happy to share the pbix file I used to create these measures. Each measure has comments explaining how I calculated the measures. Alternatively, I am happy to meet with you to explain how it is done. I don't think it will take more than 15 minutes but happy to meet for as long as you need :)
- 1 year ago
1. Contest Holder
  - 1 year ago
  why not , let me know when online
  - 1 year ago
sruthishradda
- 1 year ago
and how to calculate them
- 1 year ago
sruthishradda
- 1 year ago
i will tell all dax formula in chat
- 1 year ago
sruthishradda
- 1 year ago
plz check entry 6
- 1 year ago
ahmedfouda114
- 1 year ago
Please send the file
- 1 year ago
1. Contest Holder
  - 1 year ago
  Its not a file, its power bi and connected to company network
  - 1 year ago
2. Contest Holder
  - 1 year ago
  If you know how to manage the needed task
  DAX measures creation in lower bi , please confirm and you will need to work with me on online session
  - 1 year ago
sruthishradda
- 1 year ago
plz check entry no 6
- 1 year ago
sruthishradda
- 1 year ago
If u want i can creat same dammy table vth date ,amount and name,location
- 1 year ago
1. Contest Holder
  - 1 year ago
  Hi sai
  Nice to here from you
  
  If you are fine with the requirements please send me on chat
  - 1 year ago
sruthishradda
- 1 year ago
use salesMTD measure SalesMTD = CALCULATE ( SUM ( 'Table'[Amount] ) , DATESMTD ( 'Date'[Date] ) )
- 1 year ago
sruthishradda
- 1 year ago
to find MTD
- 1 year ago
sruthishradda
- 1 year ago
Hi contest holder,
- 1 year ago