Answering questions: running total and last dates within selection - Unplugged #38
HTML-код
- Опубликовано: 26 июл 2024
- How to apply a running total and a filter by using the last dates within the selection to the visualization explained in the article Show previous 6 months of data from single slicer selection (www.sqlbi.com/articles/show-p.... The video shows the process of exploring a solution while replying to questions received in the article comments.
Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021...
#unplugged 
Наука
"DAX is not magic", what you guys do IS the magic. Thanks for the lesson!
Excellent. I wish I could mark more likes 👍 Thank you!
It was explained in your book very perfectly, this video as bonus, with all datails Thank you very much
Thank you for sharing!
Woow excelent solve. thank you!
That's sqlbi. 👍 Thank you.
Hey Alberto!
Thanks for the video.
What Can be the dax for calculating the same period last year of running total and the same period last of the previous date. Can i achieve it by clicking on single click in filter?
Oh my god. Its amazing,!!!!!
brillante
Nice video! I have a newbie question: When should I use DAX Studio and When should I use Tabular Editor?
DAX Studio to run DAX queries, test performance, try new formulas. Tabular Editor to edit the model and create new measures. Tabular Editor 3 also has a very advanced DAX Editor included.
@@SQLBI Thanks for your prompt response! Watching you writing DAX code is enjoyable.
Sir how to handle working days,
Mon-fri
With dateinperiod to calculate average of 10 days
Because dateinperiod automatic consider saturday & sunday
See how to manage working days in this pattern: www.daxpatterns.com/standard-time-related-calculations/
@@SQLBI thnx sir