Forum Discussion
Helper IIdax
Hello All,
I am very new DAX and I mapush to work on this because of current situation. Please look into the below scenario and help me calculate the DAILY VALUE
Table Name : Sales
| Country | Date | Periodic Value | Daily Value |
| India | 1/1/2020 | 100 | |
| India | 2/2/2020 | 150 | |
| India | 3/3/2020 | 250 |
Hi AjithTravvise ,
In your DAX formula, replace "ALL" with "ALLSELECTED".
This will take into consideration any filters you are applying like the COUNTRY.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
9 Replies
- Pragati11
Super User
HI AjithTravvise ,
Can you please provide some details on how you want this DAILY VALUE to be caluclated? There is no reference in your question to what you want and it's impossible to answer.
Thanks,
Pragati
AjithTravviseNow i am unable to generate a daily sales report since i have only incremental values. I wanted to break it down to daily. I hope i am clear with my requirement.
- Pragati11
Hi AjithTravvise ,
Simple question - How can you generate daily sales if you don't have data for it? As you say you have got incremental values not daily values.
Thanks,
Pragati
- Greg_Deckler
Community Champion
Wild guess on this one because I have no idea what you are expecting for Daily Value: https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185#M111
- AjithTravvise
Hi Greg,
This worked, but when I am applying filter by Country its not working
Regards
Ajith
- Pragati11
Hi AjithTravvise ,
In your DAX formula, replace "ALL" with "ALLSELECTED".
This will take into consideration any filters you are applying like the COUNTRY.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
- AjithTravvise
I wanted to add one new column with daily value
