The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have created the DAX for linestx below -
PBI is giving some weird results for those months. However, I need PBI to consider the total revenue trend as 0 and then calculate the revenue trend. Revenue trend for May and June should be around if total revenue is 0 for those months
57838.21 | ,51566.91 |
Solved! Go to Solution.
The months are date not text. 2023 Apr is 4/1/2023
You are trying to do math with months? IE the integer representation for the first day of the month?
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
The months are date not text. 2023 Apr is 4/1/2023
That will create wonky results as the month start dates are not linear.
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |