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.
Hi All,
In the below Dataset, i wish to show the closing amount for every quarter end in a graph.
For example, in graph i wish to present the sales of Mar 1515, Jun16000 ( not the cummulative sales figures).
Please help me on the same.
Regards,
Varun
@Anonymous
I suggest you to use date instead of month name
Then creating a new measure as the screenshot below. Then you can get the result.
Hope this is helpful.
Thanks and BR
Ryan
Proud to be a Super User!
Thanx Rayan.
I'll try this and reach you incase of any help
@Anonymous
No problem. Please feel free to contact me if you have any questions.
Please kinldy mark my previous answer as a solution if it totally solved your problem. Appreciate you can give me a Kudo as well.
Thanks and BR
Ryan
Proud to be a Super User!
Hello Ryan,
Thanx this code helps for me. by any chance ist possible to help with another code to define the % increase over previous period (Variance %).
REgards,
Varun
@Anonymous,
You need to have a datetime table and use date column to build relationship with fact table and date table.
Proud to be a Super User!
Hi @Anonymous
Is the amountyou're referring to the amount for the last day of the quarter? Or the cumulative for the last month in the quarter?
Hi, Its not the Cummulative amount, it is the amount of the last Day of the quarter
I Mean, the amount is the value of the sales as on end of the last month of the quarter
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 |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |