Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Need help. I am trying to get running total for current quarter, previous quarter and previous year. My data may not have continuous daily numbers for all quarters. Some day might be missing. Below is the query which I am using. But I am getting a huge down due to non-availability of certain day in raw data. Is there any way I can get the continuous graph?
PYP&STotal=
VAR myvalue = [DayOfPQ]
var Quarter = [PQ_Name]
Prod = IF(VALUES(Revenue_Table[DayofQtr])<>[DayOfPQ],BLANK(), CALCULATE([P&SRev_PQ],FILTER(ALLSELECTED(Revenue_Table),Revenue_Table[DayofQtr]<=myvalue && Revenue_Table[Fiscal Quarter]=Quarter && Revenue_Table[Reportring_Group]="Services" )))
Ser = IF(VALUES(Revenue_Table[DayofQtr])<>[DayOfpQ],BLANK(), CALCULATE([P&SRev_PQ],FILTER(ALLSELECTED(Revenue_Table),Revenue_Table[DayofQtr]<=myvalue && Revenue_Table[Fiscal Quarter]=Quarter && Revenue_Table[Reportring_Group]="Product" )))
Return
Prod+ser
Below is the graph which I am getting as I don’t have any entry for day 10 of previous year.
Solved! Go to Solution.
Figured out the solution.
Used date table and make 1 to Many relation. took date from date table insted of master table 🙂
Hi @mruhullah,
Could you have tried to switch the 'Type' in X-Axis to 'Continous'?
If it still not work, could you please offer your sample data to have a test if possible?
Regards,
Daniel He
please follow link to see the data
https://drive.google.com/file/d/1YGbfLbCzDk_czTbVQ4Mq7AaYusPmN75y/view?usp=sharing
Can anyone help on this??
Figured out the solution.
Used date table and make 1 to Many relation. took date from date table insted of master table 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
101 | |
73 | |
70 | |
47 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |