
PowerBi DAX formula
- or -
Post a project like this1858
$100
- Posted:
- Proposals: 6
- Remote
- #2960132
- Awarded
Azure | PowerBI | SQL | SSIS | SSAS | Tableau | Javascript | Jquery | MVC .Net Core | EF Core | .Net Core API | ASP.Net |
Website Developer, Graphic Designer, Transcriber, Content writer, CAD Expert, Python Developer, Photo Editor, Web Scrapper, JAVA developer, Android developer, Wix/Shopify Expert,

Data analyst (IBM SPSS/ R/ RStudio/ Power BI) |Statistician |Excel Expert (Dashboard/ Macro/ VBA/ Power pivot)

MS Excel, SPSS, AMOS, R, STATA, Power BI, Tableau - Data Analyst, research and insights and Creative Writing

276731125437782210990111412827320371946714



Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have a powerBI dashboard that I would like to implement a DAX formula on to calculate a new visual.
In the main data set we have [A] project name, [B]# of pressings and [C] IFF date. These are the three important variables.
In a slider bar, or possibly input table on the excel master sheet we want to input [D]# of pressings we can process per day.
The vertical axis is [E] Total number of pressings available per date. Each working day we subtract [D] # Of pressings we can process per day, resulting in a new [E] Total number of pressings available per date. On a given [C] IFF date new project pressings are added to [E] total number of pressings available per date.
Please review attached for current visual (not quite working) and an excel based visual that works, but requires too much manual input.
Thanks for your help,
In the main data set we have [A] project name, [B]# of pressings and [C] IFF date. These are the three important variables.
In a slider bar, or possibly input table on the excel master sheet we want to input [D]# of pressings we can process per day.
The vertical axis is [E] Total number of pressings available per date. Each working day we subtract [D] # Of pressings we can process per day, resulting in a new [E] Total number of pressings available per date. On a given [C] IFF date new project pressings are added to [E] total number of pressings available per date.
Please review attached for current visual (not quite working) and an excel based visual that works, but requires too much manual input.
Thanks for your help,

Structurlam Mass Timber Corporation
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
1 Apr 2020
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you please share the excel file?
939425
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies